protect conditional formatting

Mikal

Board Regular
Joined
Aug 31, 2015
Messages
72
I have a sheet that has a ton od conditional formatting. I need to let users add data in all areas, but want to lock all the conditional formatting and still be able t paste into the cells etc. Is there a way to do that?
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,095,349
Messages
5,443,942
Members
405,256
Latest member
ukboyme

This Week's Hot Topics

Top