Comparing 2 Columns

[NickDP71]

Hi I have a sheet in which I need to compare and highlight rows where the values in 2 of the columns are identical.

So to explain:

Name Number Notes
ABC 1 Note 1
XYZ 3 Note 2
ABC 1 Note 3
LMN 3 Note 4
ABC 8 Note 1
XYZ 3 Note 6
XYZ 7 Note 7


In this example I would want excel to highlight the entire rows where ABC and the number 1 and XYZ and the number 3 as they are the same- but they need to be both the same in the same row.
The 3rd column, "Notes" in my example is not to be considered in the comparison.

Hope this is clear!

Thanks for your help
Nick

[Special-K]

Use Condtional Formatting, however ALL the highlighting will be the same, ie you wont get ABC 1's all one colour and all XYZ 3's another colour.

Select A2:C8

Conditional Formatting
New Rule
Use a formula to determine...

=(COUNTIFS(A$2:A$8,A2,B$2:B$8,B2)>1)

Format as required

[NickDP71]

Same colour is fine, will give it a go thanks for your help.