hi all
Looking for some code to do a simple compare column A to Column B (row 1 contains headings) and highlight any differences.
cheers
hi all
Looking for some code to do a simple compare column A to Column B (row 1 contains headings) and highlight any differences.
cheers
Last edited by Gti182; 05-09-2014 at 05:59 AM.
or something similar.Please Login or Register to view this content.
Edit: just re-read your post, that will highlight anything in column A that is not present anywhere in B and vice-versa, if you just want to compare row against row then use conditional formatting and something like:
=$A2<>$B2
as the formula
Last edited by ragulduy; 05-09-2014 at 05:56 AM.
balling! Thanks Ragukluy
i did get a "compile error: Sub or Function not defined" but changed worksheetfunctionmax to worksheetfunction.max and it worked
U can use this
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks