Conditional Formatting
 

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

--
Message posted from http://www.ExcelForum.com

Conditional Formatting
 

One way:

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

In article ,
kelleyz3 wrote:

How would I set it up where a data in a cell would be red unless it wasequal
to N, O or P?---Message posted from http://www.ExcelForum.com/

Conditional Formatting
 

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

--
Message posted from http://www.ExcelForum.com

Conditional Formatting
 

One way:

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


In article ,
RudeRam wrote:

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

Conditional Formatting
 

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

--
Message posted from http://www.ExcelForum.com