We have lot of no in a row, we want to highlight or know which are duplicates
![]() |
We have lot of no in a row, we want to highlight or know which are duplicates
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
All times are GMT -7. The time now is 01:42 PM. |