How to do with excel which able to find the duplicate entries in other cell when I enter the data in new cell in the same sheet in same column.
Thanks
Posted by
Naresh Bhuria August 13, 2008 - 10:15am
This first example will highlight duplicate rows in the range B2:B11. Select the cells that you wish to test and format, B2:B11 in this example. Then, open the Conditional Formatting dialog from the Format menu, change Cell Value Is to Formula Is, enter the formula below, and choose a font or background format to apply to cells that are duplicates.
How to do with excel which able to find the duplicate entries in other cell when I enter the data in new cell in the same sheet in same column.
Thanks
add new comment
This first example will highlight duplicate rows in the range B2:B11. Select the cells that you wish to test and format, B2:B11 in this example. Then, open the Conditional Formatting dialog from the Format menu, change Cell Value Is to Formula Is, enter the formula below, and choose a font or background format to apply to cells that are duplicates.
=COUNTIF($B$2:$B$11,B2)>1