Microsoft Office Tutorials and References
In Depth Information
Chapter 4: Chartless Visualization Techniques
Applying basic conditional formatting
Thanks to the many predefined options offered with Excel 2013, you can apply some basic
conditional formatting with a few clicks of the mouse. To get a first taste of what you can do, go the
Ribbon, click the Home tab, and choose the Conditional Formatting icon (see Figure 4-1).
Figure 4-1: Click the Conditional Formatting icon to reveal the predefined options available in Excel 2013.
As you can see, five categories of predefined options are available:
Highlight Cells Rules
Take a moment now to review what each category enables you to do.
Using Highlight Cells Rules
The formatting options in the Highlight Cells Rules category, shown in Figure 4-2, allow you to
highlight those cells whose values meet a specific condition.
These options work very much like an If…Then…Else… statement. That is, if the
condition is met, the cell is formatted; if the condition isn’t met, the cell isn’t touched.