Forum Discussion
Highlight changes to results of VLOOKUP
Hi I have several spreadsheets (customer trackers) that use VLOOKUP formulas to update data from a master spreadsheet (master tracker). Is there a way to highlight what values have changed each ...
Is there a way to highlight what values have changed each time I open a customer tracker?
In order to highlight a change, we would need to have a way to recognize that change; usually that would be accomplished through some form of time-stamp on the record.
So can you tell us how your "master tracker" spreadsheet works? Do you, for example, keep the records with a date stamp on them, so that one could identify a change based on comparing the last (current) record with the most recent prior record?
Would it be possible for you to post a copy (after removing identifiable customer IDs) of your workbook, posting it on OneDrive or GoogleDrive, with a link pasted here that grants us edit access to that workbook?