Thread
:
Cell fill color
View Single Post
#
8
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Cell fill color
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett