vlookup - how do i see/highlight changes made in the table?

[qminus]

Hello everyone,

I have a table with a lot of prices for some products, and from my 2nd excel document i pull data to update those prices with =vlookup function.

But it takes a lot of time for me to go from 1-2-3-4-5... and look at the prices and see if any price changed.

Is there a way to simply highlight or color the cell that changed so i can just scroll and see which one changed for example from 10 euro to 12 euro.

Cheers! ?

 

[maabadi]

Welcome to MrExcel Message Board. Please upload your example file & Desired results with XL2BB ADDIN or upload at free hosting site e.g. www.dropbox.com or GoogleDrive or OneDrive and Input Link here.

 

[Saurabhj]

Hi,

Please share the sheet to understand the query.

We can use conditional formatting to highlight if change in price but would like to know the sheet format (columns and price details)

Thanks,
Saurabh