Select the whole column, then from the menu: Format/Conditional formatting.
From the "Format cells if..." dropdown menu select "Custom formula is:", and write: =countif(A:A,A1)>1
From the "Format cells if..." dropdown menu select "Custom formula is:", and write: =countif(A:A,A1)>1
No comments:
Post a Comment