Conditional Formatting in a Table Cell

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
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

1. Click in a table cell with the conditional formatting
2. Click the Conditional Formatting button 
3. Modify the conditional formatting as applicable
4. Click Delete to remove the conditional formatting on the table cell
5. Click New to create new conditional formatting on the table cell