You can use conditional formatting to easily
create a Data View that applies specific styles to data values when the data
meets the criteria that you specify. You can also set conditions that change
the visibility of a data value, so you can show or hide data.
To apply conditional formatting to a Data View
- Right-click the Data View, and then click Conditional formatting.The Conditional Formatting task pane opens.
- In the Data View list, click the items in the fields that contain the data you want to format.
- Click Create, and then click Apply Formatting. The Condition Criteria dialog box opens to enable you to create a condition.
- In the Condition Criteria dialog box, place your mouse pointer anywhere in the first row, and click.
- Under Field name, click the arrow, and then click the field that you want to use in the condition.
- Under Comparison, click the arrow, and then click the operator that you want to use in the condition.
- Under Value, click the arrow, and then click More Fields.
- In the More Fields dialog box, click the field that you want to use to complete the condition
- Click OK
- In the Condition Criteria dialog box, click OK.
- In the Modify Style dialog box, select the options required to create the style for your conditional formatting.
- Click OK.
