don:

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



--


Gary


"Don Guillett" wrote in message
...
Gord, etal would appreciate it when posters FULLY state their problem in the
OP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

InsertNameDefine

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

Then in Sheet one CFFormula is: =myname123


Gord Dibben MS Excel MVP

On Sat, 29 Mar 2008 16:04:00 -0700, 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