I've been searching the site and whilst i can find many similar problems with solutions I simply don't have the ability to ammend them to suits my needs.

I have two column of data, A & C, and if a value appears in A but not in C or in C but not in A then I want to highlight the cell.

I don't want the values pulled out or pasted somewhere else, I just want them highlighted.

Ideally the solution will be in VBA so that I can integrate it into the other macros I have found on this site :-)

The two columns are different lengths (if it matters).


Thanks to anyone who takes the time to consider this.