Conditional Formatting

kelleyz3 · May 26, 2004

How would I set it up where a data in a cell would be red unless it wa
equal to N, O or P

JE McGimpsey · May 26, 2004

One way:

CF1: Formula is =AND(A1<>"N",A1<>"O",A1<>"P")

RudeRam · May 26, 2004

What it be for the opposite i.e red if it equaled N, O, P

JE McGimpsey · May 27, 2004

One way:

CF1: Formula is =OR(A1="N",A1="O",A1="P")

RudeRam · May 27, 2004

JE Thank you for the answer You have saved me a ton of wor