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.

D Domine

Thanks Greg.  You nailed the two ideas our team came up with.  Gives me great confidence we're doing all we can until they add that as a feature.  

Kennedy Stomps

Hi D-- This is on our enhancement request list and I'll add your vote for it. In the meantime, Greg has provided two great workarounds--thanks for sharing those, Greg!

Robert Chapman

Add my vote as well please. 

 

Thanks!

RNelson

Has this enhancement been added since this post? If not, can you add my vote as well.

LLisa

Has anyone found out if they have added this feature yet?