Zaigham Kazmi
Zaigham Kazmi

Reputation: 29

Invalid formula issue while applying highlighting duplicate formula in google sheet

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

Upvotes: 3

Views: 1753

Answers (1)

player0
player0

Reputation: 1

use semicolon ;

=COUNTIF(F:F; F1)>1

Upvotes: 2

Related Questions