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 •

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.


Report •
Related Solutions

Ask Question