I would like to display duplicate entries (which are allowed)in a column in red. I've tried this in conditional formatting (Formula Is)using the EXACT function to compare one cell against a range, but can't get it to work properly. I've applied the following to all cells in the column:
=EXACT(A3,$A$1:A2)
Is what I want to do possible?
Thank You
=EXACT(A3,$A$1:A2)
Is what I want to do possible?
Thank You