View Single Post
  #2   Report Post  
Steve R
 
Posts: n/a
Default

http://www.mrexcel.com/archive2/38700/44822.htm

"HSD" wrote in message
...
In the conditional formatting menu, excel only allows a maximum of 3
options.
Is there a way to add additional conditions. For example if the cell A1 =
1
colour = red, if 2 then blue, if 3 then yellow, if 4 then green.