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

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)


--
Regards
Frank Kabel
Frankfurt, Germany

Julian Campbell wrote:
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