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

Super Contributor


I have a conditional formatting with a countif formula


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


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

Create the conditional formatting rule with formula



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