Use VBA (or cond.formatting) to highlight a row if no status changein X number of days.

[Stevendeyoung]

Hi Everyone,

Is there a way to either use conditional formatting or VBA to highlight a row (columns x-x) if a certain field hasn't been updated in X amount of days? I want to make sure things on a to-do list don't get forgotten if they are low priority and get pushed down to the bottom of the list.

Any intel is greatly appreciated!

Thanks.

[Kaper]

I'd made it with combined approach:
VBA (namely: event handler for Worksheet_Change to store last date of modification see for instance: http://www.excelforum.com/excel-form...-modified.html ) and then standard conditional formatting with rule based on formula to highlight row if last change is older than X days.

[Stevendeyoung]

I will give this a shot when I get a chance today. Thanks a lot for the input, appreciate it.