Forum Discussion
Sally-S
Mar 13, 2023Copper Contributor
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 ...
Patrick2788
Mar 13, 2023Silver Contributor
'Show Changes' is a possible solution, if available in your version of Excel (I believe it's available in the 'Current' channel and Excel for the web at the moment).
https://support.microsoft.com/en-us/office/get-help-with-show-changes-in-excel-a1493bf9-25c3-470a-b970-60eceb0136e5
https://support.microsoft.com/en-us/office/get-help-with-show-changes-in-excel-a1493bf9-25c3-470a-b970-60eceb0136e5
- Sally-SMar 13, 2023Copper ContributorThank you, I will look into this!