Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Conditional Formatting
The next step is to emphasize the values greater than 70 in column C by formatting
them to appear with an orange background and white font color (Figure 2 – 44).
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Apply Conditional Formatting
The following steps assign conditional formatting to the range C4:C12. Why? After formatting, any cell
value greater than 70 will cause Excel to display the number in the cell with an orange background and a white font color.
1
Select the range
C4:C12.
Tap or click the
Conditional
Formatting button
(HOME tab | Styles
group) to display
the Conditional
Formatting menu
(Figure 2 – 44).
Conditional
Formatting
button
Conditional
Formatting
menu
New Rule
command
range C4:C12
selected
Figure 2 – 44
2
Tap or click New Rule
on the Conditional
Formatting menu
to display the New
Formatting Rule
dialog box.
Tap or click ‘Format
only cells that
contain’ in the Select
a Rule Type area
(New Formatting
Rule dialog box) to
change the Edit the
Rule Description
area.
In the Edit the Rule
Description area, tap
or click the arrow in the relational operator box (second box) to display a list of relational operators, and then
select greater than to select the desired operator.
Select the rightmost box, and then type 70 to enter the second value of the rule description (Figure 2 – 45).
What do the changes in the Edit the Rule Description area indicate?
The Edit the Rule Description area allows you to view and edit the rules for the conditional format. In this case,
reading the area indicates that Excel should conditionally format only those cells with cell values greater than 70.
New Formatting
Rule dialog box
‘Format only
cells that
contain’ rule
type selected
relational
operator
Edit the Rule
Description area
value 70
Format button
Figure 2 – 45
 
Search JabSto ::




Custom Search