Forum Discussion
Solved
Highlight Duplicates (Extended) - 2 Columns (shade both columns)
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 currentl...
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
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.