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



This is the rule for conditional formatting in the example.


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

date in the past.JPG