Microsoft Office Tutorials and References
In Depth Information
Figure 5–83. We’re looking for cells greater than 90. The 80.5 is a default selection, which Excel computed by
averaging the highest and lowest scores in the range.
Type in the Format Cells that are GREATER THAN: field. We’ve established 90
our condition: test scores above 90.
Click the drop-down arrow along the Light Red Fill with Dark Red Text entry.
That’s Excel’s default, telling you that if any selected cell meets your
condition, it will turn light red, and its text will appear as dark red. But
we want our cells to turn blue instead, so click the Custom Format…
option. You’ll see the Format Cells dialog box, as shown in Figure 5–84.
Click the Fill tab, because we want the cells that meet our condition to
turn blue, not the text in those cells.
Click a blue color in the resulting palette. Click OK.