Home > Features > Format > Conditional Formatting
Conditional Formatting
(version 1.1)
Figure 1: Conditional Formatting
This feature allows you to conditionally format a field's font color, font style (bold or normal) and cell fill color based the value in a field. Click on the button labeled Conditional Formatting on the Format tab to show the Conditional Formatting dialog box. Click the Conditional Formatting button (Figure 1: item 1) to display the conditional formatting form. The Enable Conditional Formatting checkbox (Figure 1: item 2) toggles the feature. This allows the setting to be turned on or off without changing the actual Conditional Formatting configuration.
Conditional formatting supports up to 25 conditional formats per report (see Figure 2)
| Setting | Description |
| Search Field |
Enter the field name that contains the text that contains the condition. |
| Format Field(s) |
Enter either a comma-separated list of fields that will be formatted when the condition exists. |
Figure 2: Conditional Formatting Configuration Form
Notes:
- The search is NOT case sensitive
- The search does not have to match the entire cell’s contents to be succesful
EXAMPLE : Conditionally format two fields
Download example
| Conditional Format Settings | |||
| Search Field | Format Field | Value & Format | |
| Order | ID, Order | Milk | |
| Description: Formats the ID and the Order fields (font red, cell fill color yellow) | |||
| when the Order field contains the word Milk | |||
| Original data set | |||
| ID | First Name | Last Name | Order |
| 1 | Jane | Doe | Milk |
| 2 | John | Doe | Eggs |
| 3 | Doe | Smith | Milk |
| 1 | Jane | Doe | Butter |
| Report Output | |||
| ID | First Name | Last Name | Order |
| 1 | Jane | Doe | Milk |
| 2 | John | Doe | Eggs |
| 3 | Doe | Smith | Milk |
| 1 | Jane | Doe | Butter |
EXAMPLE: Conditionally format the entire row
Download example
| Conditional Format Settings | |||
| Search Field | Format Field | Value & Format | |
| Order | [ROW] | Milk | |
| Description: Formats entire row (font red, cell fill color yellow) | |||
| when the Order field contains the word Milk | |||
| Original data set | |||
| ID | First Name | Last Name | Order |
| 1 | Jane | Doe | Milk |
| 2 | John | Doe | Eggs |
| 3 | Doe | Smith | Milk |
| 1 | Jane | Doe | Butter |
| Report Output | |||
| ID | First Name | Last Name | Order |
| 1 | Jane | Doe | Milk |
| 2 | John | Doe | Eggs |
| 3 | Doe | Smith | Milk |
| 1 | Jane | Doe | Butter |
See also