Microsoft Office Tutorials and References
In Depth Information
To Apply Conditional Formatting
3
Click the Format
button.
When Excel displays
the Format Cells
dialog box, click the
Fill tab and then click
the light red color
in column 6, row 2
(Figure 2–50).
desired fi ll color
Sample area
displays fi ll color
OK button
Figure 2–50
4
Click the OK button
to close the Format
Cells dialog box and
display the New
Formatting Rule
dialog box with
the desired color
displayed in the
Preview box
(Figure 2–51).
New Formatting
Rule dialog box
Preview box displays
format assigned to cell in
selected range if value in
cell is less than 0
OK button
Figure 2–51
 
Search JabSto ::




Custom Search