Microsoft Office Tutorials and References
In Depth Information
Highlighting Cells with Conditional Formats
Highlighting a Cell Based on Its Value
• Select the range in which you want to highlight cells that match a specified rule.
• In the Styles group on the Home tab, click the Conditional Formatting button, point to
Highlight Cells Rules or Top/Bottom Rules, and then click the appropriate rule.
• Select the appropriate options in the dialog box, and then click the OK button.
Excel has four conditional formats—data bars, highlighting, color scales, and icon
sets. In this tutorial, you will apply cell highlighting, which changes the cell’s font color
or background color based on the cell’s value. Figure 2-32 describes some of the ways
that cells can be highlighted with conditional formats.
Cells that are greater than a specified number
Cells that are less than a specified number
Cells that are between two specified numbers
Cells that are equal to a specified number
Text That Contains
Cells that contain specified text
A Date Occurring
Cells that contain a specified date
Cells that contain duplicate or unique values
Tom wants to highlight sales regions that showed an increase in sales from 2011 to
2012. With all of the data on the Monthly Sales worksheet, this information can be
difﬁ cult to locate. To make this data stand out, you will use a conditional format to display
worksheet cells with a positive value using a different font or ﬁ ll color than cells
containing zero or a negative value.
To highlight the positive sales numbers:
1. Select the range C37:J48 . This range shows the difference in sales by region and
month for 2011 and 2012.
2. In the Styles group on the Home tab, click the Conditional Formatting button,
point to Highlight Cells Rules , and then click Greater Than . The Greater Than
dialog box opens. You want to highlight those regions and months in which sales
increased, which means that they are greater than zero.
3. Type (a zero) in the Format cells that are GREATER THAN box, click the with 0
arrow, and then click Green Fill with Dark Green Text . This rule formats any
cells that display a number greater than zero in a green font with a green
4. Click the OK button to apply the highlighting rule.
5. Click cell A35 to deselect the range. Cells with positive numbers are highlighted
in green. See Figure 2-33.