Compare Columns & Highlight Unique Values

Good afternoon folks! I originally started a thread in another section regarding this topic. However, after banging my head against conditional formatting I am thinking a macro may be my best bet. Honestly, I hope I am right in that. I have a monthly report template that pulls in data from different sources. Column B lists the 2014 customer ids and column C lists the 2014 customer names while column F lists the 2015 customer ids and column G lists the 2015 customer names. The same people don't necessarily show in both. What I'd like is to compare B (2014 ids) to F (2015 ids) and C (2014 cusomters) to G (2015 customers) and highlight the new customers ids and names in F & G. Someone else runs this report so I'd like to do a macro as conditional formatting always seems like it is going to require manipulation each month. Any help would be so greatly appreciated as I think I've short circuited my brain on all this trying .


ExcelHelpMacro.xlsx

Hello,

I think I've found the solution using conditional formatting Please find the attached file below:

ExcelHelpMacro_s2.xlsx

If you need any explanation, please let me know.

Regards,
Alex

Good evening Rabbita! Thank you for the formula. I have some questions if you don't mind and I think this is where I get tripped up. This report is ran monthly by a staff member and honestly I like to try to avoid them having to edit any formulas and such. Is there a way I can say =ISERROR(VLOOKUP($F2,$B:$C,1,0)) and have this apply down to say cell 500 without it highlighting the empty cells? Knowing the data would never get to cell 500 but forcing them not to have to make adjustments. Is there a way to insert in the formula for it to only count cells with data? Its why I had kind of given up hope and thought I may have to seek assistance for some macro. I hope that isn't the case.

Please check the solution in the file below.

ExcelHelpMacro_s2.xlsx

I've changed a function in conditional formatting (COUNTIFS instead of VLOOKUP). I think it's better

I hope this is what you are looking for.

Regards,
Alex

Alex, I took a look at the Excel sheet you attached and it looks like that formula is highlighting the duplicate values. Ideally I was hoping to highlight the unique values. Any thoughts?