I have a updated version of a excel sheet (no rows have been added or deleted, only some cells in each row have been changed), I want to compare it with the original sheet and highlight the cells which have changed. I found this solution, however it marks the changed cells in a third sheet but whereas I want to highlight the changed cells in the updated sheet.


A macro would probably be best but I'm assuming your requirement is 'once off' and this can be achieved without a macro, which might be simpler. Copy your original sheet's contents into the updated one and use conditional formatting, as in example:

SU489661 example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.