Hi,
I was tasked to create a daily tracking sheet to see what cell values change each day from input users.
So there would be a summary page showing (date, field name, old value, new value).
Ideally, I want to data drop the file each day pulled from access and setup some conditional formatting to detect or compare prior day vs. today's sheet.
Index and match within a condtional formatting formula is what I'm thinking.
Anyone do this before?
I was tasked to create a daily tracking sheet to see what cell values change each day from input users.
So there would be a summary page showing (date, field name, old value, new value).
Ideally, I want to data drop the file each day pulled from access and setup some conditional formatting to detect or compare prior day vs. today's sheet.
Index and match within a condtional formatting formula is what I'm thinking.
Anyone do this before?
