Microsoft Office Tutorials and References
In Depth Information
Apply Conditional Formatting
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
2 Click the Home tab on the
3 Click the Conditional
4 Click Color Scales .
5 Click a color scale.
You can apply color bars instead
by clicking Data Bars .
Excel applies the color scale to the
How do I create a new
rule for conditional
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
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
from a cell?
To remove conditional
formatting, select the data
that contains the
formatting you want to
remove, click the
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.