Conditional Formatting

Jim Thiesse

I want to set up a condition where if a date on a sheet is more than 14 days in the past, the row will turn red. I would prefer to be able to customize how many days in the past a date would need to be to use this formatting too.

Andrée Starå

Hi Jim,

You’d have to use a so-called helper column with a formula. You can also use it together with another column for how many days it should use in the formula.

Make sense?

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!