Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

 Conditional Conditional formatting can be used in a subject report to output something different (e.g., image, value, text) based on a condition or to format based on a condition. 

 

...

Conditional Formatting in a

...

  1. Click in the table cell where the conditional formatting is to be added
  2. Click the Conditional Formatting button  Image Removed
  3. Click New
  4. Enter a name for the condition
  5. Enter a condition using JavaScript
  6. Visible
    1. If the checkbox is marked and the condition is true, the Background and Font Color specified will render
    2. If the checkbox is not marked and the condition is false, the cell does not display
  7.  Background:  The hex color code for the background color if the condition is true
    1. Enter a hex color code for the conditional background color

    2. Or: Click on the small rectangular box to select a conditional background color
      1. Click on the narrow colored rectangular column to select various ranges of that color 
      2. Click within the square box to select the specific color, the hex color code is updated in the Background box
  8. Font:  The hex color code for the conditional font
    1. Enter a hex color code for the conditional font color
    2. Or: Click on the small rectangular box to select a conditional font color
      1. Click on the narrow colored rectangular column to select various ranges of that color 
      2. Click within the square box to select the specific color, the hex color code is updated in the Font box
  9. Click Ok when completed 

 

Modifying / Viewing conditional formatting in a table cell

...

Table Cell

Conditional Formatting in a Repeater Cell

Conditional Formatting to hide a table cell or image