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

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

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

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.


Marci wrote:

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