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

conditional formatting for more than 3 conditions
 

formula is
=or(c1="data1",c1="data2",etc)
or
=or(c1={"data1","data2"})

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jai" wrote in message
...
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

conditional formatting for more than 3 conditions
 

Hi Jai

Use a formula, try


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

HTH
Peter

"Jai" wrote:

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

conditional formatting for more than 3 conditions
 

How much you wanna bet that his "data" is not really named "data"?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Billy Liddel" wrote in message
...
Hi Jai

Use a formula, try


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

HTH
Peter

"Jai" wrote:

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