Invalid formula issue while applying highlighting duplicate formula in google sheet

user_10910092 0
Viewed 70

I tried to simply apply the highlight duplicate cells formula in google sheet by adding conditional formating rule, but when I click on done it shows invalid formula.

screenshot of invalid formula

conditional-formatting google-sheets-formula google-sheets duplicates count
1 Answers

use semicolon ;

=COUNTIF(F:F; F1)>1
user_56326290
Related