Conditional Format

[Julian Campbell]

I can conditional format a cell or cells to change colour when entering up
to 2 types of text ie yes/no. But can I do the same with up to 4 or five
varients?

Thanks

 

[Frank Kabel]

Hi
yes you can. Something like
=OR(A1="text1",A1="text2",A1="text3")

or if you have these values in a range (e.g. X1:X10) try
=COUNTIF($X$1:$X$10,A1)