Conditional formatting Q

[Seanie]

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

 

[Jarek Kujawa]

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

 

[Seanie]

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