Conditional Formatting (Dates)

[karmaimages]

Hi

I'm looking for some assistance with some cells that contain dates and filling them based on a set criteria.

I can't seem to get it to work. what I'm trying to do is:

Date = Today or Past 7 days = Fill Green
Date = > 7 days fill red
Date = Blank - No fill

Anyone provide some guidance on this?

 

[Special-K99]

1) It would help if you specified the cell references. I'll assume A1:A10
2) > 7 days what does that mean? 7 days from now or more than 7 days ago? See below...

Select the cells A1:A10

Conditional Formatting
New Rule
Use a formula to determine...
3 formulas required

=AND(A1<=TODAY(),A1>=TODAY()-7)
format as green

if more than 7 days ago
=AND(A1<>"",A1<TODAY()-7)

or

if more than 7 days in future
=AND(A1<>"",A1>=TODAY()>7)

format as red

 

[Gerald Higgins]

Typo . . . ?

if more than 7 days in future
=AND(A1<>"",A1>=TODAY()+7)

 

[Special-K99]

Typo . . . ?

The board has corrupted my posted and its too late to change it now.
Yep several typos.
2 formulas required.

Select the cells A1:A10

Conditional Formatting
New Rule
Use a formula to determine...
2 formulas required

=AND(A1 <= TODAY(),A1 >= TODAY()-7)
format as green

if more than 7 days ago
=AND(A1 <> "",A1 < TODAY()-7)
or

if more than 7 days in future
=AND(A1 <> "",A1 >= TODAY()+7)

format as red