Highlighting unique values (2003)

[Cram]

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.

[dominicb]

Good morning Cram

Something like this seems to work OK. When run it will prompt for a range 1 - highlight your range in column A. When asked for range 2 select the range in column C. The unique items will then be coloured yellow (ColorIndex 6) :

Please Login or Register  to view this content.

HTH

DominicB

[Cram]

Cheers Dom, that does EXACTLY what i was looking for. I could never have solved that myself!

Thank you!

[Cram]

Is ther a way to do it without the input boxes?

It don't forsee it going further than row 100.

Ta

[dominicb]

Hi Cram

Is ther a way to do it without the input boxes?

Try this updated code. It should detect where your last cell is, and just work on the range. Take note, that it assumes that your sheet works from cell A1 (Cells(1,1)) and cell C1 (Cells(1,3)), which it may not :

Please Login or Register  to view this content.

HTH

DominicB

[Cram]

Quality!!!

Thats perfect, just tweaked the Ranges and it works a treat.

Thanks again.