Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,069
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the font case size across a worksheet HDV Excel Discussion (Misc queries) 1 December 6th 05 11:04 PM
changing default font and size in Excel Ferd New Users to Excel 1 May 23rd 05 08:44 PM
Font and size are in Excel has gone shaded. Will not let me type. Hawaiian Excel Worksheet Functions 1 April 21st 05 05:42 PM
I cannot type in my Excel program. The Font and size area is shad. ohana Excel Worksheet Functions 1 April 21st 05 04:48 PM
Changing font size in a list box [email protected] Excel Discussion (Misc queries) 1 December 21st 04 05:07 PM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"