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 Format Won't Update Cell 8
Protect conditional formatting in destination cell 2
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
How to Color a Cell Based on a Range of Cells with Colors 1
Conditional format to highlight only cells with formula, not const 2
Use of CELL("protect") in conditional formatting in Excel 07 3
copy conditional formatting range 3
IF OR AND in same conditional formula 2

Top