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