duplicate data

[Marci]

why is my "conditional formatting" option disabled on my shared worksheet? I
need to eliminate duplicates on my list.

 

[Peo Sjoblom]

You don't need conditional formatting for that, use a formula from here

http://www.cpearson.com/excel/Duplicates.aspx


Use a help column to test for the duplicates, if you insist on using CF then
you need to unshare the file first

--


Regards,


Peo Sjoblom

 

[Bob I]

Copied from Excel Help

You do not expect to change the following features, which cannot be
modified after a workbook is shared: merged cells, conditional formats,
data validation, charts, pictures, objects (including drawing objects),
hyperlinks, scenarios, outlines, subtotals, data tables, PivotTable
reports, workbook and worksheet protection, and macros.