How to protect a cell with conditional format?

R

Ruby

Hi

I have a work sheet with 20rows and few hundred columns.All the cells has
different values and so has different conditional format.the worksheet is
protected with the required cells locked.The cells with conditional format
has not locked and people unknowingly copying the cells from one to
another.And this made the conditional format(values) to change.Can anyone
tell me how to lock the conditional format so that even if they copy, the
conditional format should not change from one cell to another.Please help.
 
G

Gary''s Student

1. unprotect the worksheet
2. unlock all cells
3. Edit > Goto > Special... > Conditional formats
4. Format > Cells... > Protection > Locked
5. protect the worksheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting to Another Cell 0
Conditional format 1
Change the colour of a cell if another named cell is blank 2
Conditional Formats, how to scroll and view all formats? 0
Protect conditional formatting in destination cell 2
Conditional Format Won't Update Cell 8
Conditional Format - using 3 different cells conditions together 0
Place picture in Excel cell 0

Top