conditional formatting for more than 3 conditions

  • Thread starter Thread starter Jai
  • Start date Start date
J

Jai

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
 
formula is
=or(c1="data1",c1="data2",etc)
or
=or(c1={"data1","data2"})
 
Hi Jai

Use a formula, try


=ISNUMBER(SEARCH("Data",A1))

HTH
Peter
 
How much you wanna bet that his "data" is not really named "data"?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to select values in sequence order? 3
Splitting data in a cell 9
Transposing 2
Conditional copy 1
Print Command 1
Select to reference an other record or row 1
More than 3 Conditions 2
MailMerge Range? 4

Back
Top