How do I set up a conditional format with more than three options.
 

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.

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.

You could take a look at the free add-in at
http://www.xldynamic.com/source/xld.....Download.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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.