Overview
Conditional Conditional formatting in a table cell can be used in a subject report to output something different (e.g., image, value, text) based on a condition or to format to display a different background color and/or different font color based on a condition.
Adding conditional formatting in a table cell
- Click in the table cell where the conditional formatting is to be added
- Click the Conditional Formatting button
- Click New
- Enter a name for the condition
- Enter a condition using JavaScript (e.g. #sex==1)
- Visible
- If the checkbox is marked and the condition is true, the Background and Font Color specified will render
- If the checkbox is not marked and the condition is false, the cell does not display
- Background: The hex color code for the background color if the condition is true
Enter a hex color code for the conditional background color
- Or: Click on the small rectangular box to select a conditional background color
- Click on the narrow colored rectangular column to select various ranges of that color
- Click within the square box to select the specific color, the hex color code is updated in the Background box
- Font: The hex color code for the conditional font
- Enter a hex color code for the conditional font color
- Or: Click on the small rectangular box to select a conditional font color
- Click on the narrow colored rectangular column to select various ranges of that color
- Click within the square box to select the specific color, the hex color code is updated in the Font box
- Click Ok when completed
Adding multiple conditions to a table cell
- Follow steps 1-2 above
- The existing conditions for that cell will display
- Click the dropdown arrow to see the existing conditions
- Click New to add a new condition
- Follow steps 4-9 above
Modifying / Viewing conditional formatting in a table cell
- Click in a table cell with the conditional formatting
- Click the Conditional Formatting button
- If multiple conditions exist, select the condition to modify by selecting the name in the Condition drop down list
- Modify the conditional formatting as applicable
- Click Delete to remove the conditional formatting on the table cell
- Click New to create new conditional formatting on the table cell