Cell fill color
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
|