Conditional formatting Q
 

I know C.F. can have only 3 entries, but is it possible to enter 4
conditions within one line?

Eg. where "cell value =" A OR B OR C OR D, then format Red etc

Conditional formatting Q
 

say you have yr data in A1, then in conditional formatting window
select FormulaIs and insert:

=OR(A1="a",A1="b",A1="c",A1="d")

choose red color

then copy, paste formats

Conditional formatting Q
 

On Jan 9, 1:00*pm, Jarek Kujawa wrote:
say you have yr data in A1, then in conditional formatting window
select FormulaIs and insert:

=OR(A1="a",A1="b",A1="c",A1="d")

choose red color

then copy, paste formats

Works a treat, thanks