B bala_vb May 30, 2010 #2 sanjay;957113 said: how to find duplicate entry in one sheet and in workbook Click to expand... use conditional formating to locate duplicate entry in sheet copy this formula in conditional formating with red color for th entire worksheet. =COUNTIF(A:XFD,A1)>1 all the bes
sanjay;957113 said: how to find duplicate entry in one sheet and in workbook Click to expand... use conditional formating to locate duplicate entry in sheet copy this formula in conditional formating with red color for th entire worksheet. =COUNTIF(A:XFD,A1)>1 all the bes