Conditional Formatting
 

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.

Conditional Formatting
 

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.