View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Assigning a cell colors via IF-THEN statements

Hi,
If you've used up your 3 conditional formats, you'll have to revert to macros.
Having said that, if you just want to change the font colour only, you can
use a custom format.
The following is a paste from somewhere, but I can't remember where.
Apologies to the original author.

Value Font Color
===== ==========
< -100 Red
< -20 Blue
< 0 Yellow
< 20 Green
< 100 Maroon
= 100 Purple



The last three we'll leave for conditional formatting. The first three,
however, will be done using this format, which we enter by choosing
Format/Cells/Number/Custom:

[Red][<-100]General;[Blue][<-20]General;[Yellow]General;@

Of course, we don't have to use General - we could use any other numeric
format. The available color names are [BLACK], [BLUE], [CYAN], [GREEN],
[MAGENTA], [RED], [WHITE], and [YELLOW], or you can use any of the 56 colors
in the XL color palette by using [Color1] through [Color56]. Thanks, MVP Bob
Umlas for telling me about the latter method!

Regards - Dave.