Microsoft Office Tutorials and References
In Depth Information
Apply Conditional Formatting
Apply Conditional
Formatting
A d d r e s s
F u l l N a m e
I D
You can use conditional formatting to draw
attention to certain data in your form. For
example, you might apply a yellow highlight to
any fields containing negative values in order to
make them stand out. You apply conditional
formatting by creating a rule, which specifies the
criteria that the value in a field must meet. Values
that meet the criteria are formatted using settings
you specify.
Apply Conditional Formatting
1 Open the form to which you want
to apply conditional formatting in
Layout view.
2 Click the field to which you want
to apply conditional formatting.
3 Click the Format tab.
4 Click the Conditional
Formatting button.
3
4
1
2
The Conditional Formatting Rules
Manager dialog box opens.
5 Click the New Rule button.
The New Formatting Rule dialog
box opens.
6 Set the criteria you want to use to
apply conditional formatting.
7 Specify how values that meet your
criteria should be formatted.
8 Click OK.
5
6
7
8
310
 
Search JabSto ::




Custom Search