Kathy wrote:
I have pulled information into a spread sheet, from various sources.
I need to identify duplicates and hightlight.

I have tried conditional formating per Excel Help . . .but can't get
it to work.


You can use the COUNTIF function:

=COUNTIF(your_range,first_cell_of_your_range)1

and copy down along the column.

You will have as result TRUE for duplicates and FALSE for not duplicates.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy