conditional format

[Guest]

I would like a cell to turn red if I enter L or PB.
Normally I would use a 2 conditional formats 1 for L and 1 for PB, but I
need more than 3 conditional formats. Is there a way to combine the one for L
and PB?

 

[Dave O]

When setting up the conditional format, set condition 1 to "Formula is"
and use a formula like this:
=OR(A1="L",A1="PB",A1="X")
You can set as many conditions as an OR() statement will accommodate:
30.

 

[Guest]

Thanks Dave that worked great.