Formula to highlight a row a when a date is 10 days past or more?

Occasional Visitor

Hi I'm in a bind. I'm rebuilding a date tracker and I want to highlight a row when a date in a column (D) is 10 days past or more.  Could someone provide a formula for that?

1 Reply

@DaveCSCKCDDS 

=$D2<=TODAY()-10

This is the rule for conditional formatting in the example.

=$A$2:$I$18

This is the "applies to" range in the example.

date in the past.JPG