Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Font color based on font type or size
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Font color based on font type or size
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Font color based on font type or size
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 "Earl Kiosterud" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the font case size across a worksheet | Excel Discussion (Misc queries) | |||
changing default font and size in Excel | New Users to Excel | |||
Font and size are in Excel has gone shaded. Will not let me type. | Excel Worksheet Functions | |||
I cannot type in my Excel program. The Font and size area is shad. | Excel Worksheet Functions | |||
Changing font size in a list box | Excel Discussion (Misc queries) |