Conditional Format Form
The Conditional Format form will appear after you have defined a condition for a particular field. The name of that field will be displayed at the top of the form. The form allows you to define formats, and also provides the ability to add and delete conditions relating to the selected field.
The condition or conditions you have specified will be listed in the Conditions box at top left of the form. While you cannot edit conditions, you can delete them and add others.
In the example shown here, the field is an identification field called Task Manager and the condition is John, so that any cost item whose task manager is John will have the conditional formatting applied to it.
You may specify:
1. Colors – text, background and border
2. Border width
3. Font characteristics - size, bold, italic and underline
4. Uppercase text
In the example shown above, the selected format is yellow background, i.e. any cost item whose task manager is John will be shown with a yellow background.
Range of Application
The conditional format may apply just to the selected field, or to the entire row of data in which that particular item of data occurs. Click on the required option in the box at lower left of the form.
In the example shown above, the Entire row option has been chosen, so that any cost item whose task manager is John will be shown with a yellow background across the entire row of data.