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.
Hello,
Uploading a sample file will be necessary to get the right help
Uploading a sample file will be necessary to get the right help
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
Deleted
If I get your question correctly, all you need to do is select all the data using CTRL + A
Then, click on Conditional Formatting > Highlight Cells Rules and Duplicate values. See the caption below