Welcome to Lesson 5 of the Intermediate Microsoft Excel Tutorial. In this lesson we will cover Conditional Formatting. I hope you enjoy the lesson.

Conditional Formatting

Step 1: Select Cell(s)

Select the cell or cells that you want the conditional formatting to apply to.

Step 2: Conditional Formatting

Select Format and then Conditional Formatting.

Step 3: Select Condition

Select the condition that you want the formatting to apply to. You can select to apply the formatting if a cell is a certain value, or if a formula is

Step 4: Format

Click the format button. From here you can select the formatting that you want to be used when the condition is met.

Step 5: Additional Conditions

You can click on the Add button to select additional conditions and formatting that can be applied to this cell or cells.

Step 6: Complete

Click on OK and you formatting will be applied based on the conditions set.