Highlight Duplicates (Extended) - 2 Columns (shade both columns)

[Tony2021]

hello, 

I have a conditional formatting with a countif formula

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

it correctly highlights but I want to extend the highlight to column B as well.  

It currently highlights column A only. 

How can I do this? 

Please see attached file. 

[#2 · Accepted solution]

@Tony2021 

Select A2:B7. The active cell should be in row 1.

Create the conditional formatting rule with formula

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

[#3]

Perfect. I see there was a small change. the $. thanks! Works great.