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

[HSD]

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.

 

[Steve R]

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

 

[Bob Phillips]

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

--

HTH

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