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:
Also I'm no expert here, trying to learn as I go.
So if the column has these values (each in their own cell):
I would want the A's and B's to turn red.