View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emile
 
Posts: n/a
Default Conditional formatting for more than 3 variables

I would like to test a cell (A1) for a number between 1 and 9.
Depending on the value returned I would like to format the cell (A1) with a
specific color
Example:

If A1 =1 then format cell yellow
If A1 = 2 then format cell blue
If A1 = 3 then format cell red
If A1 = 4 then format cell green
and so on to 9

Where do go to find the standard colors and their respective color number?

Thanks for any help

Emile