Identifying non-similar data

[gz3s36]

I have data in column C. Some of which is the identical. I sort column C. I need to highlight data in columns A & B that is not the same when the data in C is the same. Should look like the example in the download.

[shg]

Select A3:B34, CF > Use a formula,

=($C3=$C2) * (A3<>A2) + ($C3=$C4) * (A3<>A4)

	A	B	C
2	S	D	EMPN
3	1	71	214150005
4	3	51	215161342
5	1	15	219107724
6	1	15	315152538
7	1	73	315152538
8	2	51	315172826
9	1	27	317101601
10	1	27	317101601
11	1	27	317151391
12	2	19	317151391
13	2	11	318115984
14	3	45	412106286
15	1	27	417169715
16	1	71	419122036
17	2	71	419122036
18	1	27	516130629
19	1	27	517155863
20	1	73	613107638
21	2	03	618114175
22	2	03	618114175

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[gz3s36]

Well I spoke too soon. The macro did highlight some cells that weren’t equal but it also highlighted some cells that were equal.

[MickG]

Have a look at your returned file, I can't find much wrong with the results now.

[gz3s36]

MickG has done it again. Thank you.

[gz3s36]

MickG solved the first part but now I want to compare columns H & V. If there is a number match then I need to compare D to S and also compare E to T. If D≠S then highlight S in yellow and if E≠T then highlight T in yellow. I don’t know if it’s possible.

[JeteMc]

Two conditional formatting formulas that accomplish what you want are:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Let us know if you have any questions.

[gz3s36]

That seems to be the ticket. Thank you.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.