Highlighting first time a value appears in Google Sheets-CodePudding

Home > Mobile > Highlighting first time a value appears in Google Sheets

Highlighting first time a value appears in Google Sheets

Time：07-30

Is it possible to highlight cells where a value appears for the first time?

Eg:

A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 1
A6 = 2

So in the above A1-A4 would be highlighted but A5-A6 wouldn't as they are repeats of the same value

CodePudding user response：

Try this: with apply to range set A1:A1000 take a look at the

lock $ the row of the range of

and the reverse of it would be:

=INDEX(COUNTIFS(A:A,A1,ROW(A:A), "<="&ROW(A1)))=1