Click the Format button. Click the Fill tab, choose blue, and click OK. ... Conditional formatting is powerful, but you can avoid frustration by learning how and when Excel evaluates rules.

Create additional conditional statements by highlighting the same cells, clicking the "Conditional Formatting" button again and making another selection. Save the workbook when you are finished.

On the Home tab, click the Conditional Formatting button in the Styles group, then select New Rule from the menu. A New Formatting Rule dialog box will open. In the Select a rule type list, ...

Click Conditional Formatting button in the Styles group. Click New Rule in the menu. Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.

Click on "Conditional Formatting" and choose the "New Rule" option if your rule isn't listed on the menu. ... Click the "Format" button to set formatting elements such as highlight color and font.

Learn how to apply advanced formatting to your tabular data using Excel's conditional formatting options. ... Step 5: Choose the formatting option(s) you want by clicking on the Format button.

Conditional formatting can help you get the information you need from data. For example, suppose you would like to know how many students in your class received an above-average score on a recent ...