How can I protect only certain formulas and conditional formatting in a worksheet while still allowing the cells to remain open for data input?
Review/Protect Sheet... or Home/Format/Protect Sheet... seem to be all-or-nothing.
Also, how can I make the protection apply only to certain cells but not to others? The Excel help info indicates that I can select a range for protection but I can't make it work. The whole procedure seems to be about protecting the entire sheet, not protecting a range or individual cells.
Appreciate your help!
Review/Protect Sheet... or Home/Format/Protect Sheet... seem to be all-or-nothing.
Also, how can I make the protection apply only to certain cells but not to others? The Excel help info indicates that I can select a range for protection but I can't make it work. The whole procedure seems to be about protecting the entire sheet, not protecting a range or individual cells.
Appreciate your help!