Bill,

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

--

HTH

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


"Bill Brehm" <don't want any spam wrote in message
...
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