Spreadsheets – Conditional Formatting & Protection

Lesson Aims

Be able to conditional format a spreadsheet
Be able to protect a worksheet
Be able to validate data on a spreadsheet

Task 1

Download the spreadsheets below and practice Conditionally formatting the spreadsheet and protecting cells within the spreadsheet