Highlight duplicate cell only if 2 columns match

[excelnewbie726]

I am trying to figure out how to highlight column A only if column B also is duplicated. The use case is a list of employees and their managers. I only want to highlight cells that the employee and manager match. If the attached snip, I would want cells A2 and A4 highlighted. This seems like a simple problem and I bet it is but I haven't been able to find the solution in the threads I have looked at. Any help is appreciated.

Thank you

 

[Joe4]

Welcome to the Board!

You can do this pretty easily with Conditional Formatting.
First, select the cells starting in cell A2 down to the bottom of your data.
Then go to Conditional Formatting, click "New Rule", and choose the "Use a formula to determine which cells to format" option.
Then enter this formula:

=countifs(A:A,A2,B:B,B2)>1

Then click the Format button, go to the Fill tab, and choose the yellow color and click OK.

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B
1
2	Tom Pearce	Bill Brewer
3	Tom Pearce	Jan Stewer
4	Tom Pearce	Peter Gurney
5	Tom Pearce	Bill Brewer
6	Dan'l Whiddon	Peter Gurney
7	Dan'l Whiddon	Peter Davy
8	Dan'l Whiddon	Peter Davy
9	Dan'l Whiddon	Harry Hawke
10	Dan'l Whiddon	Tom Cobley
11
12
13
Parts

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A100	Expression	=COUNTIFS($A$2:$A$100,A2,$B$2:$B$100,B2)>1	text	NO

 

[excelnewbie726]

Thanks both of these worked. One weird thing I ran into though. If I selected all of column A by click the column A header, it would produce incorrect results. When I clicked and dragged from A1 down, the formula worked as expected. Any idea why the difference?

 

[Fluff]

The first row in the formula must match the first row in the applies to range.
So if you select the entire column, then the A2 & B2 need to be change to A1 & B1

 

[excelnewbie726]

I knew it was something stupid that I was missing. Thank you so much for your help!

 

[Fluff]

Glad we could help & thanks for the feedback.