3

I'm trying to use conditional formatting to make all the values in one column that are the same turn red. I used arrayformula, but I can only get it to do that for the first value in the column.

I tried this in the custom formula and applied it to all the cells in the column: =ARRAYFORMULA(IF(F1:F10=F:F,1,0))

Also I'm no expert here, trying to learn as I go.

So if the column has these values (each in their own cell):

A
A
B
D
B
N
G

I would want the A's and B's to turn red.

1 Answer 1

2

Please select ColumnF and apply a Custom formula is of:

=countif(F:F,F1)>1  

Select your format.

COUNTIF

For your locale you might need ; rather than ,.

2
  • 1
    Worked like a charm. I really appreciate it.
    – MKN
    May 19, 2017 at 14:29
  • 2
    @MKN Could you please mark as the answer? Thanks! :)
    – Ashton
    Aug 17, 2017 at 1:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.