View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jai jai is offline
external usenet poster
 
Posts: 71
Default conditional formatting for more than 3 conditions

Hi,
Is there any solution for the following :

I have six type of conditions, if any condition is met, cell colour should
be yellow. For example, if cell value is any one of the following :

DATA1
DATA2
DATA3
DATA4
DATA5
DATA6

All cells containing above should show yellow colour in the file.

Please help.

Thanks,
Jai