macro to compare a range with a standard range and highlight cells, when not matched

Hi Gurus,

I have a standard codes and regions in a sheet which is a standard format for all time use.

i would be getting a report in which regions would be wrong for some of the codes.

please help me with a macro which should compare my report with standard format and highlight regions (cells) which are wrong.


I have attached a sample for the reference.

You can Simply get it from Vlookup formula and you wont see any wrong entries

Please Login or Register  to view this content.

yes i can use the vlookup... but i will get a report to check and colour the wrong entry...pls help through a macro..

You wont get Wrong entry if you use above.... as False in Vlookup means exact match.....

i understand Mr. NAVEEN.

i know to use vlookup for this scenario but what i am doing is a verification process in which i get a report and i need to compare that with standard report and highlight wrong values...hope u understood

Anyway, we have an Excellent Tool in Excel.. Macro recorder... just start recording and do Vlookup where you want result in excel and stop recording.... You have your macro......

hi Naveen,

Here i dont want a exact match... i just need to color the wrong entry in the list compared with standard format....

Try this code, you need to change the code like adjust ranges and worksheet names....

Please Login or Register  to view this content.

Hi Naveen,

i need a macro to just compare each code of my report with standard code and find whether right region is place.


or else the region cell has to be highlighted..


without vlookup, i need a macro

Check attached...
you can run macro using ALT +F8 from your excel

i have got a new idea by your macro. Thanks a lot.