Microsoft Office Tutorials and References
In Depth Information
Apply a Conditional Format to a Range
Apply a Conditional
Format to a Range
You can make a worksheet easier to analyze by
applying a conditional format to a range. A
conditional format is formatting that Excel applies
only to cells that meet the condition you specify. For
example, you can tell Excel to apply the formatting
only if a cell’s value is greater than some specified
amount.
When you set up your conditional format, you can
specify the font, border, and background pattern,
which helps to ensure that the cells that meet your
criteria stand out from the other cells in the range.
Apply a Conditional Format to a Range
1 Select the range you want to
work with.
2 Click the Home tab.
3 Click Conditional Formatting .
4 Click Highlight Cells Rules .
5 Click the operator you want to
use for your condition.
An operator dialog box
appears, such as the Greater
Than dialog box shown here.
6 Type the value you want to use
for your condition.
A You can also click the Collapse
Dialog button ( ) and then
click a worksheet cell.
Depending on the operator,
you may need to specify two
values.
7 Click the with and then
click the formatting you want
to use.
B To create your own format,
click Custom Format .
Search JabSto ::




Custom Search