MS Excel 2003 - Lesson 13: Using Conditional Formatting in Excel

This guide provides a clear, practical overview of "MS Excel 2003 - Lesson 13: Using Conditional Formatting in Excel". It organizes the most useful details, explains important considerations, and highlights the steps or choices that matter most.

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

- As per the above illustration, we will highlight all the values from 4 to 6, so enter the numbers in the correct fields. - If you click the OK button, the formatting will not be applied to those values. Therefore, you click the Format button

- The Format Cells dialog box appears, from which we can specify how the data is displayed. - From the Color section: select a color, choose red for the example above. - When finished, click the OK button. The Conditional Formatting dialog box appears again. - To add other conditional formats, click the Add button. Otherwise, click the OK button to dismiss the dialog box.