Ms Excel - Lesson 13: Use Conditional Formatting in Excel

Ms Excel - Lesson 13: Use Conditional Formatting in Excel covers the essential facts behind the topic, including what changed, why it mattered, and how it affected users.

Microsoft Excel Overview

- Select the area you want to apply conditional formatting. In this example, the selected area is A1: C5. - From the Format menu, click Conditional Formatting.

- According to the above illustration, we will highlight all values ??from 4 to 6, so enter the numbers into the corrected fields. - If you click the OK button, formatting will not apply to those values. So, click the Format button

- The Format Cells dialog box displays, from which we can specify how data is displayed. - From the Color menu: select a color, choose red for the example above. - When done, click the OK button. The Conditional Formatting dialog box is displayed again - To add other conditional formats, click the Add button. If not, click the OK button to skip the dialog.