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 words which a person used as a response for a particular instruction. What I need is to highlight those cells in each column which are duplicate. The most important thing is that the columns are independent so I am not looking for a way how to highlight duplicates which would be across the columns. I know how to use conditional formatting for each particular column but it takes several mouse clicks to do it and I have around 150 columns so it would be ridiculous to do it one column at a time... I would be grateful for any sensible solution for this problem! Many thanks in advance!
Best,
Mysliik
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.
6 Replies
- Hello,
Uploading a sample file will be necessary to get the right helpI 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.
