Friday, 20 January 2017

highlight cell if value duplicate in same column for google spreadsheet

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

No comments:

Post a Comment