Hi All,
See attached. I need a macro that will compare the "New Range" with the "Original Range". If there is a value in the new range that is not in the original range, I would like a msg box to appear and say "Invaild ID Number" and then highlight either the cell or the text in Red.
Thanks In Advance
Last edited by jbmerrel; 04-06-2012 at 03:00 PM.
Why not use a formula. Insert this in C3 =IF(ISBLANK(B2),"",IF(ISERROR(VLOOKUP(B2,A:A,1,0)),"X","")) and highlight Column C > Conditional Formatting, New Rule, enter =$C1="X", and select your custom format
I wish I could but it must be a macro in this case. I have other things in columns C-AE. I need the macro to just check the one column and compare it to the original range.
Thank you for your response
Insert this to your worksheet module
Please Login or Register to view this content.
Thank you!!!!!!
No message box, and no VBA. Conditional formatting can still highlight in red.
Pauley
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks