fLAGGING A CELL

[MARKEGANDERSON]

hello All-

How can I identify a cell if the information has not been changed for over 5 days.

i am working on a report that track the hours of each asset, if the hours have not been changed, i want to highlite it red.

 

[Jerry Sullivan]

Hello,

One approach would be to use a corresponding set of cells (perhaps the adjacent column) to hold values that represent the time or date "stamp" when each watched cell was last changed.

Once you have that, you could use Conditional Formatting to highlight the cells that have a stamp that is more than 5 days old.

If you would like some help doing that, please explain a bit more about your process. Are you the only person using this workbook or it accessible to many people?

Excel isn't intended for secure applications, so I wouldn't recommend this unless it is acceptable to you that the system could be overriden.