Solved Excel 07 Conditional Formatting

February 3, 2012 at 08:49:15
Specs: Windows Vista
I need to highlight cells with dates in a spreadsheet that are more than 14 months old. I cannot figure out the formula to do so. For example: the date in B1 is 8-APR-11 (written in the formul,a bar as 4/8/11) I want it to be highlighted red if it is older than 14 months from today. ( I have a few cells that have 7-MAY-10 in them, so those should be highlighted.)

See More: Excel 07 Conditional Formatting

Report •

February 3, 2012 at 11:02:18
✔ Best Answer
Here is a =DATEDIF() solution:


Here's how to use it:

Conditional Formatting 2007

1) Select your cell or range of cells. IE B1

2) On the ribbon click Conditional Formatting

3) Click on New Rules, it’s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.

5) Enter the formula: =DATEDIF(B1,TODAY(),"m")>14

6) Click on the Format button

7) Select the Fill Tab

8) Select a pretty color

9) Click OK

10) Click OK


Report •
Related Solutions

Ask Question