Hi
i am using excel 2010.i am actually using the following formula =IF(A2=A1,1,0) to find duplicate values in a column.The result is shown as 0, 1, 0 ,1, etc. whenever the values are not duplicate the formula returns 0, 0.Now I want to use conditional formatting to highlight only those cases which appear as 0 but only if they are consecutive .
Kris
Bookmarks