Prev: Copy within a subtotal
Next: Count occurance of months
From: Jai on 28 May 2010 11:23
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
From: Don Guillett on 28 May 2010 11:30
formula is
=or(c1="data1",c1="data2",etc)
or
=or(c1={"data1","data2"})

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Jai" <Jai(a)discussions.microsoft.com> wrote in message
news:5A6EA284-4153-4F37-A84C-461023497765(a)microsoft.com...
> 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

From: Billy Liddel on 28 May 2010 11:36
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
From: Don Guillett on 28 May 2010 13:59
How much you wanna bet that his "data" is not really named "data"?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"Billy Liddel" <BillyLiddel(a)discussions.microsoft.com> wrote in message
news:450991CF-4A55-4D70-B6CA-C019D379A3B5(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Copy within a subtotal
Next: Count occurance of months