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 currently highlights column A only.
How can I do this?
Please see attached file.
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
2 Replies
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.
