Highlighting cells depending on val

Dell / Xpsm1210
January 17, 2009 at 14:13:53
Specs: Windows XP Home SP1, T5600/1 GB
Hi, I'm having some trouble with conditional formatting in Excel (i'm using windows vista). I want Excel to highlight a cell if the value of that cell equals another one eg. if cell A1 is less than 6 months old, then highlight cell B1 OR if cell A1 is between 6 months and 2 years old, highlight cell C1, etc.
I would appreciate help on this, thanks!


See More: Highlighting cells depending on val

Report •


#1
January 19, 2009 at 10:36:21
The condition will refer to the cell where the criteria is entered.

So use the condition in B1 and the other condition in C1 to match your criteria.

HTH
Bryan


Report •
Related Solutions


Ask Question