If your data is in A1, then try formula is:

=(A1="EA")+(A1="P")+(A1="UA")+(A1="H")+(A1="E")+(A 1="L")0
--
Gary's Student


"Burntbiskit" wrote:

Hi there!

I am trying to apply conditional formatting to a spreadsheet in the 2003
version. My problem is, I am only allowed to have 3 conditions, but I need
6. I'm unsure if I can do an IF or THEN formula.

My spreadsheet looks like this:

Day Status
1 EA
2 P
3 H
4 EA
5 UA

I want the status column to be highlighted in Red, if there is anything
other than P, EA, UA, H, E, or L.

Can someone tell me if this is possible in 2003?

I'd appreciate any help. :)
--
Thank you!