Protecting Conditional Formatting

[Ade]

Is it possible to protect the conditional formatting in the cells on a
worksheet, while still allowing the contents of the cells to be changed.

Basically I want to be able to protect the column headings at the top and
also the conditional formatting in the data cells but still allow the
'contents' of the data cells to be changed.

 

[Earl Kiosterud]

Ade,

Use worksheet protection (Tools - Protection - Protect Sheet). You must first unlock any
cells (Format - Cells - Protection tab) in which changes to cell contents are to be allowed.

 

[Ade]

Cheers Earl, the problem is that If I unlock the data cells to allow the cell
values to change, I can't then protect the conditional formatting that I have
for these cells.

 

[David Biddulph]

Yes. Set the data cell protections to unlocked, but when you protect the
worksheet, make sure that the protection options don't allow users to
"Format cells".