Lock cells but allow colour formatting or comments

Please purchase the course before starting the lesson.

You can lock cells but allow colour formatting or comments which don’t affect the security of the formula but allow a user to provide some sort of feedback to you. Note that adding comments is different from formatting so it requires a different setting.

 

Lesson tags: vlookup
Back to: Excel Tools Course > Protecting spreadsheet information and formulas