Applying Conditional Formatting
Conditional formatting enables you to automatically draw attention to interesting, exciting, concerning, unusual, or other data. Uses of conditional formatting include:
- Highlighting the highest or lowest numbers in a report.
- Highlighting numbers above or below a certain number.
- Highlighting specific values with specific colors.
- Drawing attention to specific dates.
- Highlighting cells that contain specific text.
- Highlighting numbers within a certain range.
- Visually displaying the values within cells.
Conditional formatting functionality includes:
Highlight Cells Rules. Highlight numbers greater than, less than, between, or equal to specific numbers. Also highlight cells that include specific text, dates with a specified range, and duplicate values.
Top/Bottom Rules. Highlight the top or bottom X or X% results in a data set, or numbers that are above or below average.
Data Bars. Visually display values by filling portions of cells with colors based on the values.
Color Scales. Visually display values by associating cell colors with the values in the cells.
Icon Sets. Visually display values using icons.
Formatting Based on Values in Other Cells. Formatting can be based on the value within the cell itself or on the value within another cell.
To apply conditional formatting:
- Choose the cell or cells to which you wish to apply conditional formatting.
- On the HOME tab, in the Styles group, click the Conditional Formatting command:
- Select the rule or format you wish to apply by clicking on it:
- If necessary, fill out the requested information in the dialog box that appears.
Watch and follow along as your instructor shows you some of the many ways you can use conditional formatting.