Hi Stephen,
The advantage of C.F. is that it doesn't matter how the value
changes by manual entry or by formula. But since you have
more than 3 color choices for any individual cell you would
have to use an Event Macro.

Event Macros
http://www.mvps.org/dmcritchie/excel/event.htm#case

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Stephen" wrote in message ...
Hi,
I'm tring to fnd out if it is possible to add more than 3 conditions to any cell? (is there a way to write a formula that would do
this? Or is there a way to applied one formula to 2 differnt true statements?)
To give you an example: I have 5 differnt criteria. On, Off, AM, PM, Night. I have the defalt as Off in black. then I have the
following in the conditional formatting "On" white background, "PM" yellow background, "Night" 40% gray background. Now, I need to
add "AM"! Trying to add it to "On" with a "On" or "AM" in the format.