Solved Excel Conditional Formatting Question

May 14, 2012 at 10:13:04
Specs: Windows XP
I am using Excel 2003 in which I am maintaining a database of Material Safety Data Sheets (MSDS) each MSDS expires 3 years after the issue date. I need know how to to change the cell colour of each cell when the expiry date is reached.

See More: Excel Conditional Formatting Question

Report •

May 14, 2012 at 12:23:35
✔ Best Answer
If all you want to do is color the cell or cells
on or after your date has reached 3 years
try this:

I'm using 2007, so you may need to adjust these instructions for 2003:

With your Issue Date in cell A1

Select cell or range of cells
On the Task Bar
Select Format - Conditional Formatting
On the first dropdown, choose Formula Is
For the formula, enter:


Click the Format button.
Select a pretty font colour .
Click OK
Click OK

What the formula does is simply adds three years to your issue date in cell A1 and compares it to todays date.

See how that works.


Report •
Related Solutions

Ask Question