Forum Discussion
Formula to highlight a row a when a date is 10 days past or more?
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
=$D2<=TODAY()-10This is the rule for conditional formatting in the example.
=$A$2:$I$18This is the "applies to" range in the example.
