Adding Color Conditions to Quick Grid Cells

Use color to condition grid elements based on predefined metric values. This allows you to visually represent metric values and ranges without using JavaScript. Additionally, cells update live with selected color properties as users update and modify metrics and cell values that meet conditions. For example, you may choose to condition cells with risk metrics greater than 5 to display as red. Grid cells with risk values greater than 5 display as red in the project, deliverable, or activity to which they are associated.

To add color-conditional formatting:

1. From the System menu, select Page Design > Quick Grids.

2. Create a new quick grid or open an existing quick grid.
3. Select the cell containing the metrics and values you want to condition. Condition values are evaluated against the selected cell's value in a case insensitive manner.
4. Navigate to the Appearance tab on the right panel and select the color picker for text, background, or border color.
5. Click the Conditions tab and click to add a condition.
6. Select the color, enter its hexadecimal color code, or enter its RGB or HSV value in the color field.
7. Select the condition operator and enter the criteria that sets the condition.

Enter a specific condition value matching the metric in the selected cell or enter a field code.

Enter dates using the YYYY-MM-DD format.

8. Click away from the box to set the condition.
9. Repeat steps 5-8 to add additional conditions.

If multiple conditions are entered, each condition is treated individually and respected on a per-condition basis.

The cell displays the color of the first condition met and you can use the same color in different conditions for the same element property. For example, a cell selected to display as red if the value is greater than 0 can also be conditioned to display as red if the cell value is less than 10.

If conditioned cells do not meet any conditions, the default background, text, or border color displays.

10. Click Save in the lower right corner of the page to save changes, Save and Close to save the configuration and close the editor, or Cancel to close the editor without saving changes.

Notes:    To delete a condition, open the color picker where the condition is set and click the Conditions tab. Click for the specific condition.