PDA

View Full Version : Ask a question about excel 2007


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