SOLVED

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

Regular Contributor

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. 

Tony2021_0-1640119215784.png

 

2 Replies
best response confirmed by Tony2021 (Regular Contributor)
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

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