Apply Conditional Formatting

Automatically colour cells that meet a rule — like scores below 60.

You will learn to

• Create a "less than" highlight rule

How it works

Conditional formatting changes a cell’s appearance when it meets a rule. Select cells, choose Home → Conditional Formatting → Highlight Cells Rules → Less Than, and enter a value.