Any way to have more than three conditional formats?

[Bill Brehm]

We would like to set the background color of cells depending on their
values. But the number of legitimate values is higher than three. There are
at least five legimate values plus it would also be nice to display
illegimate values yet another color. Any tricky ways, like having a legend
on the spreadsheet and looking up and applying the background color from the
legend?

Thanks,

Bill

 

[Bob Phillips]

Bill,

This needs event code. There is a free addin that does this at
http://www.xldynamic.com/source/xld.CFPlus.Download.html

--

HTH

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