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 |
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 |
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 |
All times are GMT +1. The time now is 04:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com