I've created a spreadsheet for my work to calculate the number of patrons and
sales. I would like to protect only the cells that have formulas in them, so
that the formulas cannot be changed or erased.

When I highlight a cell that I want to protect, I have tried going to
"format cells" and then clicking on "protect"; but a pop up window appears
and tells me that I must turn "sheet protection" on first. However, when I do
that, the entire sheet is locked and I cannot enter in the daily guest counts.

Anybody have a solution?