Conditional Formatting and OR

[Vanessa Simmonds]

Good Evening,

How can use the formula OR in conditional formatting?

I want a cell to turn red if the value is either "A" or "B".

Is it possible?

Thank you very much.

Vanessa Simmonds

 

[Elkar]

Use this formula in your Conditional Format.

=OR(A1="A",A1="B")

HTH
Elkar