Forum Discussion
Highlight duplicates across multiple columns
I have a worksheet with 5 columns. Each column contains anywhere from 10k to 20k rows. I am looking for a way to highlight the cells that appear in every column. I am thinking this is a formula in co...
=AND(COUNTIF($A$1:$A$26,A1)>0,COUNTIF($B$1:$B$26,A1)>0,COUNTIF($C$1:$C$26,A1)>0,COUNTIF($D$1:$D$26,A1)>0,COUNTIF($E$1:$E$26,A1)>0)Maybe with this rule for conditional formatting which seems to work in my sheet. The formula can be adapted to more rows as required.