Microsoft Office Tutorials and References
In Depth Information
Apply a Conditional Format to a Range
Formatting Excel Ranges
8 Click OK.
C Excel applies the formatting to
cells that meet your condition.
Can I set up more than one condition for a
Yes. For example, you could set up one
condition for cells that are greater than some
value, and a separate condition for cells that
are less than some other value. You can apply
unique formats to each condition. Follow Steps
to to configure the new condition. 8
How do I remove a conditional format from a
Follow Steps to to select the range and 3
display the Conditional Formatting menu,
and then click Manage Rules . Click the Show
formatting rules for and then click This
Worksheet . Click the conditional format you
want to remove and then click Delete Rule .
Click OK to return to the worksheet.