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.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"John" wrote in message
...
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