Excel 2010 Conditional Formatting

July 6, 2011 at 02:43:29
Specs: Windows 7, CORE 2 DUO

I need some help with the above, basically I'm trying to conditionally format a cell to highlight, for example, (Excel 2010)

12.06.2010 (cell A2) is greater than 14.06.2009 BY A MINIMUM OF 7 MONTHS (cell A1), highlight cell A2.

Thanks in advance, (if I don't make sense please let me know)


See More: Excel 2010 Conditional Formatting

Report •

July 6, 2011 at 07:34:13
See if this works for you:

This is for Excel 2007

1) Select your cell or Range of Cells: A2
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: =IF(DATEDIF(A1,A2,"m")>=7,TRUE,FALSE)

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