Hi Experts need your help...
I need to change the cell fill color (in a cell in sheet one) based on the
cell value (in a cell in sheet two).

Thanks

Mir Khan

Conditional formatting is the way to go. However, you cannot use a reference
to another worksheet or workbook in conditional format but what you can do is
in some out of the way area of your worksheet you can make a cell = the cell
on the other worksheet and then you can refer to a cell on the same worksheet
for the conditional format.

Example say Sheet1!AA3 = Sheet2!A3.

Use following formula for the conditional format on Sheet1:- =AA3=3

--
Regards,

OssieMac


"Mir Khan" wrote:

> Hi Experts need your help...
> I need to change the cell fill color (in a cell in sheet one) based on the
> cell value (in a cell in sheet two).
>
> Thanks
>
> Mir Khan

You can do this with Conditional Formatting if you create a name for the sheet
two cell.

With Sheet two selected.

Insert>Name>Define

myname......refers to: =Sheet2!D5

Then in Sheet one CF>Formula is: =myname>123


Gord Dibben MS Excel MVP

On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan <(E-Mail Removed)>
wrote:

>Hi Experts need your help...
>I need to change the cell fill color (in a cell in sheet one) based on the
>cell value (in a cell in sheet two).
>
>Thanks
>
>Mir Khan

On Sat, 29 Mar 2008 17:00:01 -0700, OssieMac
<(E-Mail Removed)> wrote:

>you cannot use a reference
>to another worksheet or workbook in conditional format

Not entirely true.

See my reply to OP


Gord

Thanks for the quick response...

Hi Gordon conditional formatting worked good for me but it has limit of 3
conditions and i have more than 3 conditions to use. Is there any other
alternative.

I appreciate your help.

Thanks

Mir Khan

"Gord Dibben" wrote:

> You can do this with Conditional Formatting if you create a name for the sheet
> two cell.
>
> With Sheet two selected.
>
> Insert>Name>Define
>
> myname......refers to: =Sheet2!D5
>
> Then in Sheet one CF>Formula is: =myname>123
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan <(E-Mail Removed)>
> wrote:
>
> >Hi Experts need your help...
> >I need to change the cell fill color (in a cell in sheet one) based on the
> >cell value (in a cell in sheet two).
> >
> >Thanks
> >
> >Mir Khan
>
>

Thanks Gord. Another thing I have learnt. My main reason for being involved
with this forum is that one learns so much from it and that's the second one
today from yourself.

--
Regards,

OssieMac


"Gord Dibben" wrote:

> On Sat, 29 Mar 2008 17:00:01 -0700, OssieMac
> <(E-Mail Removed)> wrote:
>
> >you cannot use a reference
> >to another worksheet or workbook in conditional format
>
> Not entirely true.
>
> See my reply to OP
>
>
> Gord
>

maybe you could use something like this

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

--


Gary


"Mir Khan" <(E-Mail Removed)> wrote in message
news:ACD126DE-AAA5-43AF-B371-(E-Mail Removed)...
> Thanks for the quick response...
>
> Hi Gordon conditional formatting worked good for me but it has limit of 3
> conditions and i have more than 3 conditions to use. Is there any other
> alternative.
>
> I appreciate your help.
>
> Thanks
>
> Mir Khan
>
> "Gord Dibben" wrote:
>
>> You can do this with Conditional Formatting if you create a name for the
>> sheet
>> two cell.
>>
>> With Sheet two selected.
>>
>> Insert>Name>Define
>>
>> myname......refers to: =Sheet2!D5
>>
>> Then in Sheet one CF>Formula is: =myname>123
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan
>> <(E-Mail Removed)>
>> wrote:
>>
>> >Hi Experts need your help...
>> >I need to change the cell fill color (in a cell in sheet one) based on the
>> >cell value (in a cell in sheet two).
>> >
>> >Thanks
>> >
>> >Mir Khan
>>
>>

Gord, etal would appreciate it when posters FULLY state their problem in the
OP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Mir Khan" <(E-Mail Removed)> wrote in message
news:ACD126DE-AAA5-43AF-B371-(E-Mail Removed)...
> Thanks for the quick response...
>
> Hi Gordon conditional formatting worked good for me but it has limit of 3
> conditions and i have more than 3 conditions to use. Is there any other
> alternative.
>
> I appreciate your help.
>
> Thanks
>
> Mir Khan
>
> "Gord Dibben" wrote:
>
>> You can do this with Conditional Formatting if you create a name for the
>> sheet
>> two cell.
>>
>> With Sheet two selected.
>>
>> Insert>Name>Define
>>
>> myname......refers to: =Sheet2!D5
>>
>> Then in Sheet one CF>Formula is: =myname>123
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan
>> <(E-Mail Removed)>
>> wrote:
>>
>> >Hi Experts need your help...
>> >I need to change the cell fill color (in a cell in sheet one) based on
>> >the
>> >cell value (in a cell in sheet two).
>> >
>> >Thanks
>> >
>> >Mir Khan
>>
>>

don:

i thought mvp's were able to discern everything that everybody was trying to
do.<g>



--


Gary


"Don Guillett" <(E-Mail Removed)> wrote in message
news:%23ekt%(E-Mail Removed)...
> Gord, etal would appreciate it when posters FULLY state their problem in the
> OP.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Mir Khan" <(E-Mail Removed)> wrote in message
> news:ACD126DE-AAA5-43AF-B371-(E-Mail Removed)...
>> Thanks for the quick response...
>>
>> Hi Gordon conditional formatting worked good for me but it has limit of 3
>> conditions and i have more than 3 conditions to use. Is there any other
>> alternative.
>>
>> I appreciate your help.
>>
>> Thanks
>>
>> Mir Khan
>>
>> "Gord Dibben" wrote:
>>
>>> You can do this with Conditional Formatting if you create a name for the
>>> sheet
>>> two cell.
>>>
>>> With Sheet two selected.
>>>
>>> Insert>Name>Define
>>>
>>> myname......refers to: =Sheet2!D5
>>>
>>> Then in Sheet one CF>Formula is: =myname>123
>>>
>>>
>>> Gord Dibben MS Excel MVP
>>>
>>> On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan
>>> <(E-Mail Removed)>
>>> wrote:
>>>
>>> >Hi Experts need your help...
>>> >I need to change the cell fill color (in a cell in sheet one) based on the
>>> >cell value (in a cell in sheet two).
>>> >
>>> >Thanks
>>> >
>>> >Mir Khan
>>>
>>>
>

For sometime, we have been trying, without success, to get Bill Gates to pay
for mind reading classes for MVPs.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:(E-Mail Removed)...
> don:
>
> i thought mvp's were able to discern everything that everybody was trying
> to do.<g>
>
>
>
> --
>
>
> Gary
>
>
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:%23ekt%(E-Mail Removed)...
>> Gord, etal would appreciate it when posters FULLY state their problem in
>> the OP.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "Mir Khan" <(E-Mail Removed)> wrote in message
>> news:ACD126DE-AAA5-43AF-B371-(E-Mail Removed)...
>>> Thanks for the quick response...
>>>
>>> Hi Gordon conditional formatting worked good for me but it has limit of
>>> 3
>>> conditions and i have more than 3 conditions to use. Is there any other
>>> alternative.
>>>
>>> I appreciate your help.
>>>
>>> Thanks
>>>
>>> Mir Khan
>>>
>>> "Gord Dibben" wrote:
>>>
>>>> You can do this with Conditional Formatting if you create a name for
>>>> the sheet
>>>> two cell.
>>>>
>>>> With Sheet two selected.
>>>>
>>>> Insert>Name>Define
>>>>
>>>> myname......refers to: =Sheet2!D5
>>>>
>>>> Then in Sheet one CF>Formula is: =myname>123
>>>>
>>>>
>>>> Gord Dibben MS Excel MVP
>>>>
>>>> On Sat, 29 Mar 2008 16:04:00 -0700, Mir Khan
>>>> <(E-Mail Removed)>
>>>> wrote:
>>>>
>>>> >Hi Experts need your help...
>>>> >I need to change the cell fill color (in a cell in sheet one) based on
>>>> >the
>>>> >cell value (in a cell in sheet two).
>>>> >
>>>> >Thanks
>>>> >
>>>> >Mir Khan
>>>>
>>>>
>>
>
>