I have a speadsheet with thousands of different values. Everytime someone
makes a change to a cell value I would like it to automatically change the
formatting to highlight it.

I would then reset the conditonal formatiing a t the beginning of each week.

is there a way?