I have a sheet with cells I need to Lock. Once I do that and then protect the sheet, users can input data into unlocked cells but they can't change formatting (colors) on any cell in the sheet. I only wanted to lock certain cells, not disallow formatting in every cell.
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.