Microsoft Office Tutorials and References
In Depth Information
Apply Conditional Formatting
EXCEL
chapter 9
Building Spreadsheets
If the value of a selected cell
meets the condition, Excel applies
the conditional formatting.
Apply a Color Scale
1 Select the cell or range that
contains the conditional
formatting.
2 Click the Home tab on the
Ribbon.
3 Click the Conditional
Formatting button.
4 Click Color Scales .
5 Click a color scale.
2
3
4
5
1
You can apply color bars instead
by clicking Data Bars .
Excel applies the color scale to the
conditional formatting.
How do I create a new
rule for conditional
formatting?
You use the New Formatting
Rule dialog box to set a new
rule and formatting for the
condition that you set. To
open this dialog box, click the
Conditional Formatting
button on the Home tab, and
then click New Rule . Use the dialog box to define
the condition of the rule, as well as what formatting
you want to apply when the condition is met.
How do I remove
conditional formatting
from a cell?
To remove conditional
formatting, select the data
that contains the
formatting you want to
remove, click the
Conditional Formatting
button on the Home tab, and then click Manage
Rules . Next, click the rule that you want to
remove, and click Delete Rule . Click OK to close
the dialog box.
161
 
Search JabSto ::




Custom Search