Hello,
I want to compare 2 excel tabs (Old and new ) to highlight differences in new tab with yellow color and also highlight newly added entries in New tab with another color.
Plz Help me with the vba code.
Thanks In Advance
Hello,
I want to compare 2 excel tabs (Old and new ) to highlight differences in new tab with yellow color and also highlight newly added entries in New tab with another color.
Plz Help me with the vba code.
Thanks In Advance
Hello im_neel and Welcome to Excel Forum
An advanced search (top right corner of page) of this website brings up hundreds (at least) of threads on the subject.
Keyword(s) "highlight differences sheets" (without quotation marks)
be sure to check the box next to Posts.
Everything else should be fine.
One thread that looks similar is: https://www.excelforum.com/excel-pro...eadsheets.html
If those threads don't address your issue then please upload a manually highlighted sample so that we may attempt to replicate the highlighting.
To upload Attach a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks