I think I got it.
I turned on CF for the second cell in the range of cells within the column.
I used this formula: =COUNTIF($B$9:$B10,$B10)>1 and applied a colour
I copied that cell and pasted the formats only for the range I am using.
Testing it shows that the first value that has duplicates is not coloured
but any duplicates below are.
"Brad P" <firstname.lastname@example.org> wrote in message
> I have a column where each cell has a number. There may be duplicates.
> Let's say A4 is 365. And A34 is 365. I would like to highlight the
> duplicate value in A34 but not in A4. If 365 is also located beyond A34
> I'd like to highlight that as well. Is this possible?