Conditional Formatting dates in the past

[m27mitchell]

Is there a way to create conditional formatting for past dates? I'm trying to make the cell green if it's a date in the past 15 days (to today), yellow if it's 15 - 30 days old, and red if it's 31 or more days old.

Any help is greatly appreciated.

Than you

 

[RasGhul]

<today()-15,$j1>Hi m27,

Highlight the column/Conditional Format/New rule/Use a formula to determine which cells to format;


Green 15 days old;

=$J1>TODAY()-15

Yellow 15-30 days old;

=AND($J1"less than"TODAY()-15,$J1>TODAY()-30)<today()-15,$j1>

Red 31+days
</today()-15,$j1><today()-15,$j1>

=($J1"less than"TODAY()-31)

Html code doesn't like the less than character in the forum.</today()-15,$j1></today()-15,$j1>