Highlight If Older Than 'X' Days

D Domine

I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days.  It's helpful for us to see which tasks are stale.

However, there's only an option for "In the last 'x' days" or "older than (a date)".  Has anyone found a good workaround or submitted this as a feature request?

Greg Gates

I think it's a great feature to request! In the meantime, I can think of at least two workarounds:

 

1) Format everything in your column or sheet to have a red background (or whatever you want the "late" color to be). Then, in your conditional formatting, have it change the cell background to the normal white color if it's "In the last 30 days." It's kind of backwards thinking, but should technically produce the desired effect.

 

2) Create a new column solely for calculating the age of a task. Your formula could look something like "=TODAY() - [Date Column]1". Then, apply your conditional formatting to the desired cell/row based on the value in this column if the value is bigger than 30.