Sudeep Raghav
Jul 11, 2012, 02:26 AM
We have lot of no in a row, we want to highlight or know which are duplicates
JBeaucaire
Jul 11, 2012, 01:20 PM
You can highlight the row of data and use CONDITIONAL FORMATTING to color the cells that are duplicated.
If the cells were in row2, you would:
1) Highlight Row2
2) Open Conditional Formatting
Apply a new custom rule with the formula:
=COUNTIF(2:2, A2)>1