"sramsey" wrote
.. want to highlight any duplicates just within column C
....I followed the formula for the conditional formatting
but no luck =IF(COUNTIF($C:$C, C2)1,TRUE,FALSE) ..

Select col C,
then use as the Condition 1,
Formula is: =COUNTIF($C$1:C1,C1)1
Format to taste and ok out

The above will trigger the cond format in col C's cells
containing duplicates (i.e. 2nd instances, 3rd instances, etc)

Alternatively, we could also flag duplicates in col C
in an adjacent empty col D (say) by putting in D1:
=IF(C1="","",IF(COUNTIF($C$1:C1,C1)1,"Dup",""))
then just copy D1 down as far as required

Col D will return "Dup" for duplicates found in col C
(Can then use autofilter* on col D to filter out "Dup")
*via: Data Filter Autofilter, with a new top row added
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---