Forum Discussion
How to conditionally format many columns independently
Hi, I am struggling to find a solution for a problem I encountered. I have a data sheet with many columns and each column represents data from an individual person. In each column, there are word...
Deleted
I'd apply to this range
conditional formatting rule with formula
=(B2<>"")*(COUNTIF(INDEX($B$2:$N$1048576,0,COLUMN()-1),B2)-1)See in second sheet attached.
I am attaching a sample with only 14 columns but this should give you an idea. The cells with the pink background are duplicates, the rest are unique values in a given column.
Deleted
I'd apply to this range
conditional formatting rule with formula
=(B2<>"")*(COUNTIF(INDEX($B$2:$N$1048576,0,COLUMN()-1),B2)-1)See in second sheet attached.
- This is absolutely perfect! Many thanks!
You are welcome