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

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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