Excel if statements with dates

Microsoft Office excel 2007 home & stude...
July 27, 2010 at 09:25:47
Specs: Windows XP

I am trying to do the following in Excel:

If the date in column Q1, is 30 days over the date in column P1, outline or fill Q1 in a color. Is this an IF statement or conditional formatting?

Thank you!

See More: Excel if statements with dates

Report •

July 27, 2010 at 09:57:27
Conditional formatting is what your looking for:

1) Select your cell, Q1

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(P1+30<=Q1,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