Conditional Formatting in a Table Cell

Owned by Mary Lukowski
Last updated: Apr 22, 2016

Overview

Conditional formatting in a table cell can be used to display a different background color and/or different font color based on a condition. 

 

Adding conditional formatting in a table cell

  1. Click in the table cell where the conditional formatting is to be added
  2. Click the Conditional Formatting button 
  3. Click New
  4. Enter a name for the condition
  5. Enter a condition using JavaScript (e.g. #sex==1)
  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 

 

Adding multiple conditions to a table cell

  1. Follow steps  1-2 above
  2. The existing conditions for that cell will display
  3. Click the dropdown arrow to see the existing conditions
  4. Click New to add a new condition
  5. Follow steps 4-9 above

Modifying / Viewing conditional formatting in a table cell

  1. Click in a table cell with the conditional formatting
  2. Click the Conditional Formatting button 
  3. If multiple conditions exist, select the condition to modify by selecting the name in the Condition drop down list
  4. Modify the conditional formatting as applicable
  5. Click Delete to remove the conditional formatting on the table cell
  6. Click New to create new conditional formatting on the table cell