Color Schemes #2
How do you export custom color schemes to Microsoft
Office Frontpage 2003?
You do not really expect interoperability do you <shaking head in disbelief>
...Change payment term
Hi I set up a loan account that has a monthly repayment.
Overtime, I changed my actual bank loan account to have a weekly repayment
and would like to update this information in Money 06, but Money refuses to
do so. Any help/info is appreciated.
...Change of public IP for fighting spam
If I ask my dns registor to change my ip to another public ip. Is this
going to help us fight spam? Is there's a risk of not getting email?
Example old: www.company.com = 184.108.40.206
Examble new: www.company.com = 220.127.116.11
By the way, I noticed that most big companies cannot be ping anymore. Is
this advisable too?
On Thu, 20 Apr 2006 08:06:02 -0700, RickyVene
>If I ask my dns registor to change my ip to another public ip. Is this
>going to help us fight spam? Is there's a ris...Mail Merge Publisher 20002 with Outlook 2000 Fails
I have Publisher 2002 and can not get Publisher to
recognize Outlook 2000 files.I am getting the error
Unable to obtain list of tables from data source.
The trouble shooting help says that data source may be
busy. However when using Word 97, mail merge works fine.
In Word I can see that the file type for the Outlook file
is *.olk. However Pulisher does not appear to recognize
this file type, scanned Open Data source file types.
Does anyone know how to resolve this?
...get a colored text in one cell to appear the same way in others
I would like to have a cell that says "great" and is colored purple to
appear the same way whenever I type the word "great"
Format>conditional format>formula is>=a1="great"><select formating>
Adjust cell location as required
> I would like to have a cell that says "great" and is colored purple to
> appear the same way whenever I type the word "great"
Use conditional formatting, select the range of cells wheer you wan
"great" to be coloured purple, then from the for...Issues with publishing web page using Publisher 2007
I notice is that the menu isn't showing up in Firefox but it is in Internet
Explorer. However some images are showing in FF and seem missing in IE.
Not sure what would be causing this, please provide feedback
You probably have the menu and the missing images on a master page. Nothing
on the master page will been seen in FF or other browsers, and should not be
used in a Publisher web. Move everything to the main pages, and you should
be good to go.
If you have more questions about Publisher webs, then post in the web group
and we will try to help you there:
news://msn...different color file names
I have not seen this before but my boss showed me some of
his xl file names are blue and some black. I have not been
able to figure this out.......any clues?
Like in windows explorer?
I think some versions of windows will show you mapped drives in a different
color. And some will show compressed files (.zip's) in a different color.
I use win98 at home and I don't have this option.
But next time you're in windows explorer, look for Folder Options (or just
Options) under one of the menu items. See if there's a setting for what you
If you have trouble, you may want ...color
Does anyone know what the formula or blurp is that you can
change the color of a cell or text when it changes. i
want the word late to be red. and the words on-time to be
bold black. does anyone know how to do that?
Use conditional formatting. Go to Format|Conditional formatting, then, for
Condition 1 select "Cell Value is" "equal to" and in the last box type in
"late" (no parens). Click on format and select red for the font color. Next,
click on Add>> and repeat the same for "on-time"
"Courtney" <email@example.com> ...Color of day
Why is the entire day colored. I have many b'day colors on other days and
the entire day isn't colored. I can't find an answer to the original
The all day events on the colored dates are marked to Show time as Busy.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.CO...How do I define colors that are automatically applied to data seri
How do I define the colors that are automatically applied to data series?
Tools menu > Options > Color tab. Make changes to the bottom two rows of
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> How do I define the colors that are automatically applied to data series?
...How to stop RichEdit color change overriding default color
I've got a handly little syntax editor going along (that--so far-- is
waaay faster than the examples on codeguru.com (if you'd like to know
how to speed them up, I spotted a logic flaw in two of them. If
you're interested, just email me). I have a question on a different
syntax editor I'm writing for an in-house language though, so you'll
notice some unique features that enable me to take shortcuts.
But I've got a funny little problem. If the user is typing at the end
of the rich edit control, and they type in a keyword and it gets
colored, any text typed after tha...How to view a PDF file opening as Excel?
I'm stuck using our kid's computer today and I downloaded a PDF file and it
will only open in Excel. How do I change this?
in the Windows explorer you may change the reference to the file
"good1" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I'm stuck using our kid's computer today and I downloaded a PDF file
> will only open in Excel. How do I change this?
Associate the file back to Adobe Acrobat...right click on th...PivotChart conditional colors
My PivotChart shows all of the batches that one worker must complete. Each
batch has a status of "not yet started", "in progress", or "complete". I
would like to change the color of each batch based on the status.
I know this is possible, but I do not know where to put the code or what
code I would write.
...changing the from e-mail address
Hi there, is anybody aware of a way to configure a CRM
user so that CRM e-mail sent from the SFO client would
show a different e-mail address in the "from" field
(email@example.com instead of the real e-mail address
of the user) so that replies to such e-mails would go to
the support mail box?
...How to change the font size
I have MS Money ver 14 and find the font size far too small, is there a way
to increase the size? The older version I used for years did have this
feature but so far I have not found it in the new one.
I'm not sure what older version you had.
The only way to change font size is to change it globally for the whole
system. Money reacts to the system font. It has no other control over font
size except in reports and check printing.
"L. Peter Stacey" <firstname.lastname@example.org> wrote in message
>I have MS Money ver 14...Changing grayed out payees?
How can I change grayed out payee names, payees that were
e-pays? I have written e-pays to CP&L and CPL and CP& L.
I want them to all be changed to one payee, but since they
were e-pays they are grayed out. So is there anyway I can
fix my error?
How to change color of button control on a dialog.
>How to change color of button control on a dialog.
Not easy. You have to make it owner drawn and do it all yourself. Have
a look on sites such as codeproject and codeguru, there are bound to
be examples there.
MVP VC++ FAQ: http://www.mvps.org/vcfaq
You will need to make the button control (CButton) owner draw.
There are lots of useful examples showing how to do just that at
This class has ton's of options for buttons:
http://www.codeproject.com/buttonctrl/cbuttonst.a...How do I change text to a different case
Each person on my list has put their own name in themselves, in upper and
lower and a combination of both cases. How do I get it to be one or the
other without re-typing each name? (there are thousands)!
Let's say the names are in A1:A1000
In B1 (insert a new column if needed) enter =PROPER(A1)
Copy this down to B100 - the quickest way is to double click the fill handle
(little solid square in lower right corner of active cell)
Now you have a column with "bad" data and one with "good" but the good data
comes from formulas that rely on the bad data.
Select the good...Access to all Colors
Operating System: Mac OS X 10.5 (Leopard)
I have a workbook that I have used a number of colors from filling cells, cell borders, and color of text within cells. But many colors I would like to use do not appear when I want to fill a cell with a color or change Text in a cell to a specific color. It appears the only colors I have available to me are based on Themes that I select in the Formatting Palette. When I change the theme to access color I want, colors in my workbook change to undesirable colors. <br><br>How can I get all the colors availa...Automatically Color by Type of Resource
I'm trying to set up my Gantt to automatically color by Type of Resource. So
basically if I had human resources and equipment, how do I set up MSP to
automatically change the Gantt bar color depending on which resource I select?
So I select a human, its turns BLUE, if I select equipment its GREEN.
I this article posted by Rod Gill which was helpful but I can't figure out
how to do Type
Looks like one way might be to use the Resource Group column but I'm limited
to their names and on..."Replace all" changes formatting
I have formatted a column to text. Currently in the column is a list copy
and pasted from MAS 500. Contents of each cell look something like this:
SO-0000001016. With the column formatted as text, I did Edit/Replace,
replacing SO- with nothing, intending to remove simply the SO- and leave the
six zeros. However, it wipes out the six zeros, as well, leaving simply
1016. If I manually remove SO- on every number, the six zeros remain. What
Yes, Excel is a great document tool but it has its limitations as well. The
zeros before a number value has always been a litt...Change Campus to Inactive When There Are No Programs Listed.
I have a form for campuses, with a subform that lists all of the
advisors for that particular campus. What I want to have happen is, if
after deleting an advisor from the subform, I want the computer to
automatically place a check mark in a box marked "Inactive" on the
main form, but only if there are no other active advisors for that
location. I've tried a number of different things, but nothing is
working the way I want. Suggestions?
Try this after backing up your database ---
UPDATE [campuses] LEFT JOIN [advisors] ON [campuses].campusID =
[advisors].campusID SET [campuses].I...how do I change profile
I used the Office Customization Tool to setup Office 2003. Part of it has
the settings for my Exchange Server. (So when a new user logs onto the
computer and launches Outlook it sets it up for them.)
My Exchange Server now has a new name so the automatic setup no longer
Where do I find the file on the particular PC that does this setup, and how
can I change it?
...How to get one variable to equal the value of a changing variable (its hard to explain in the subject)
Dim CurrMenu as ???Dim MenuNo As IntegerDim Menu1ItemCount as Integer, Dim Menu2ItemCount as IntegerMenu1ItemCount = 1Menu2ItemCount = 3Menu3ItemCount = 5 etcDo While MenuNo < whatever MenuNo = 1 CurrMenu = "Menu" & Str(MenuNo) & "ItemCount" & ".Value" MenuNo 1LoopWhat I'm trying to do is set CurrMenu to Menu1ItemCount (not the textbut the value of the variable). How do I do that? I've tried to putwords together so that it equals 'Menu1ItemCount.Value' but obviouslythat does not work because it thinks its text, not the valu...color fields
Is it possible to work with the color of a field?
eg: Counting the amount of red field?
Message posted from http://www.ExcelForum.com/
Microsoft MVP - Excel
"dragoncf >" <<email@example.com> wrote in message
> Is it possible to work with the color of a field?
> eg: Counting the amount of red field?
> Message posted from http://www.ExcelForum.com/