Automatically highlight edited cells until beginning of week

[auslegung]

We have a spreadsheet shared on a network drive that we manually highlight every time we make a change, then clear all highlights Monday afternoon and start over. I'd like to automate this process. I know this can be done, with the exception of it being cleared automatically Monday afternoon.

What can I do so that whenever a cell is edited, it is filled with yellow until Monday afternoon rolls around? If that's not possible, please walk me through how to have it fill with yellow when edited, and we can clear all highlighting manually.

Thanks!

[Mallycat]

This is a non trivial problem. In order to do this, you need to keep track of whether the Monday reset has been done or not. If you try to automatically reset each time the sheet is open on a Monday, what happens if it is not opened one Monday, and what happens if it is open twice on Monday?

I would do it this way
Write a clear highlighting macro. This is easy. Just start the macro recorder, select the entire range that will ever need to be cleared, clear the formatting, the stop the macro.

Write a macro that records the date of the last reset in a column

Write a macro that compares today's date with the last reset date. If a reset is due, run the reset macro and then run the "record reset date" macro.