Changing Font color based on font type or size

[John]

My wife has a large book collection the she keep track of in Excel. She wants
to have the colors of titles of book different from title of series and or
author. Is there a easy way to do this other than changing the font color
every time. The color she wants is not in the standard color pallet. Any info
would help

 

[Earl Kiosterud]

You can set up any of the colors in a workbook palette for any color you want, then use it
for font, cell fill, etc. Tools - Options - Color. The changed color will be part of the
paletter for only this workbook.


You can use conditional formatting to change the font color after you've set up the colors
you want to have available.

 

[John]

I think that will be easier that what she wanted. Her original plan was
trying to figure how to have her color of choice in the standard colors in
Excel07. This way she will be able to just up date the whole cell with all
the formating options she needs