Highlight only cells with updates

Hello All,

I select / copy a range of data (may have text and numbers) from spreadsheet A and paste (as values) to spreadsheet B. Even though it will replace all the data, I would like to highlight (in yellow) only the cells that changed with new values. For example, if the cell had "300" and I replace with "300" it should not highlight.

Is there a way to automatically highlights only the cells with changed values after I pasted the range ?

Thank you.

Can you paste the new data to a separate sheet? That way you can run code to ascertain the difference in value and highlight the different values.

try

Please Login or Register  to view this content.

Hi,

maniacb - I tried your code but not sure why it didn't work. I have attached a sample file with your code, the "Source" sheet with lines showing the range that I will select to copy and in red the changes that should be highlighted in yellow after comparing with the "Target" sheet.

Vraag en antwoord - I also tried your code before and after pasting from "Source" to "Target", but got an error.

Any idea why is not working? thank you.

Here is a non-looping macro that I think should also work...

Please Login or Register  to view this content.

maniacb - your code works, but is highlighting the cells with no changes. I need to highlight the changes.

Rick - your code works, so after applying the highlights I can paste the data (as value) to the "Target" sheet and send the updates by email.

Thank you all for your help.

I corrected the inaccurate highlighting with post #6

No additional functionality is required, the code works prefect to highlight only the changes. I will mark post as solved,

Thank you all for your help!