From http://www.cpearson.com/excel/duplicat.htm

To create a named range, select the entire area of values, then type a
name (Range1) into the 'Name Box' on the formula bar.

-"Highlighting Duplicate/Unique Entries
We use Excel's Conditional Formatting tool to accomplish this. First,
highlight the entire Range1. Then, select the Conditional Formatting
tool from the Format menu: Format-Conditional Formatting.
Change the "Cell Value Is" option to "Formula Is" and enter the
following formula in the formula text box:-


Code:
--------------------
=IF(COUNTIF(Range1, A5)1,TRUE,FALSE)
--------------------


-Where A5 is the first cell in Range1. Then, click the Format button
and select the font or background color you want your cell formatted
with. Finally, click OK. Duplicate entries in Range1 will be formatted
as you selected. For example, if "Able" occurs twice in Range1, both
occurrences of "Able" will appear highlighted."-

To highlight unique entries, switch the formula to
Code:
--------------------
=IF(COUNTIF(Range1, A5)1,FALSE,TRUE)
--------------------



Scott


--
hannons
------------------------------------------------------------------------
hannons's Profile: http://www.excelforum.com/member.php...o&userid=33465
View this thread: http://www.excelforum.com/showthread...hreadid=532633