Highlight rows that haven't been updated in 60 days yellow, 90 days orange

Mary Anne Dunn

Hi team -

I've been thinking about this for a couple of days and searching the site to get an answer. I've not found an obvious solution so reaching out to see if anyone has done this before. I created a Modified + 60 days column and Modified + 90 days column but there doesn't seem to be a way to trigger cell highlighting (we're trying to be subtle) vs. changing a cell value.

Any ideas you have are appreciated!

Mary Anne

SSFeatures

Hi @Mary Anne Dunn, one way that you can do this is the following:

1. You already have your "Modified" column which tracks when the row was modified.
2. Create a new column named "Flag Aging".
3. Add the following formula, and apply it as a column formula (right click a cell and click "Convert to Column Formula")

=IF(
    TODAY() - Modified@row >= 90, 
    "90+", 
    IF(
      TODAY() - Modified@row >= 60, 
      "60+", 
      ""
    )
)

This formula checks if the most recent modification is older than 90 days, and if so then it puts the value "90+" in this cell. If it's older than 60 days then it puts "60+".

4. Create a conditional format on the "Flag Aging" column. If the value is "60+", make the row yellow. If the value is "90+", make the row orange.

5. (Optional) Hide the "Flag Aging" column.

Hope this helps!

SSFeatures

Hi @Mary Anne Dunn, one way that you can do this is the following:

1. You already have your "Modified" column which tracks when the row was modified.
2. Create a new column named "Flag Aging".
3. Add the following formula, and apply it as a column formula (right click a cell and click "Convert to Column Formula")

=IF(
    TODAY() - Modified@row >= 90, 
    "90+", 
    IF(
      TODAY() - Modified@row >= 60, 
      "60+", 
      ""
    )
)

This formula checks if the most recent modification is older than 90 days, and if so then it puts the value "90+" in this cell. If it's older than 60 days then it puts "60+".

4. Create a conditional format on the "Flag Aging" column. If the value is "60+", make the row yellow. If the value is "90+", make the row orange.

5. (Optional) Hide the "Flag Aging" column.

Hope this helps!

Mary Anne Dunn

Thank you so much, exactly what I needed! Brilliant.

Best to you.

SSFeatures

You're welcome! Glad it worked!