How to create a conditional formatting rule

There are many different kinds ofconditional formatting, but the basic steps are the same for all types.

Let’s take a look.

Here we have a table that shows five test scores for a group of students.

Let’s create a conditional formatting rule to highlight all test scores over 90 in green.

To create a new conditional formatting rule, first go for the cells you’d like to format.

Then, select an option from the Conditional Formatting menu.

Once we click OK, the rule is created and applied to our worksheet.

We’ll look at how to add more conditional formatting rules to your worksheet in the next lesson.