Hi need some help with conditional formatting and using a formula to create the formatting.
I have conditional formatting for duplicates for the first column, so all 6 in the first column are highlighted. What I want to do is create a formula to highlight cells if there is a duplicate # in the first column with a different # in the second column. If all the #s in the first column are the same and all the #s in the second column are the same, it would not be highlighted. The goal is to show any duplicates but with different data in the second column.

2005906 193145
2005906 193145
2005906 193145
2005906 193145
2005906 303722
2005906 303722

Hope this makes sense.