HIGHLIGHTING DULPICATES WITH TWO COLUMNS & DELETING DUPLICATE
 

Sirs,
I request formula if Col-A & B Having Duplicate (NOT ONE COLUMN), that cells
to be highlighted. (AS PER BELOW SAMPLE - ROW 1 & 5 OF COL-A & B TO BE
HIGHLIGHT) And for another application, i want to delete the duplicate cells
or rows.(CELL - A5 TO BE DELETE) PLEASE FIND THE SAMPLE DATA
COL-A COL-B
AC-A3654-023-02 2
AC-A3654-023-02 4
AC-A3655-024-03 1
AC-A3654-023-03 2
AC-A3654-023-02 2
Request you to help on this & save my time.

-PERANISH