I am working with a Excel Sheet that is meant as an Informational file , I am hoping I can find something to do that will automatically change the background color of the cell that was modified for say 7 days ( just to alert the users that, that is the new information) and then go back to being the same as the rest of the sheet. I have tried conditional formatting but I haven’t been able to see how to formulate it because the value will change periodically and can’t be pre determined.
Bookmarks