Versions Compared
Version | Old Version 2 | New Version Current |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Note |
---|
The information on this page is for use by Alpha Testers only. This feature is still in development and therefore, this documentation is subject to change. |
You might be familiar with conditional formatting if you use other spreadsheet products, such as Microsoft Excel. It is a feature that allows you to apply a color code to cells, based on
...
rules that you create. The color coding makes the important numbers stand out visually, drawing other users' attention directly to them. This visual aid is particularly useful in grids that contain a lot of data, where key insights can be easily lost.
You can apply the conditional formatting to one column in the grid, using up to three rules.
For example, suppose you want to
...
quickly see if your Sales Reps are meeting the current month’s revenue target. You can use the Conditional Formatting feature to apply a standard traffic light color scheme to the current month column, where the revenue generated above the target displays in green, at the target displays in yellow and less than the target displays in red.

Add rules
Set up the grid to display the required data. You cannot change the grid setup while you are in Conditional Formatting mode.
Click the Conditional Formatting button
...
in the
...
top right toolbar above the grid. The grid converts into
...
Conditional Formatting mode,
...
with the conditional formatting options
...
displayed above it.
Create the rules that determine the formatting:
Click Select a column and select the column to which you want to apply the formatting.
Click the Lock* button,
...
if applicable (see note below for more information).
Click Condition and select the condition to which you want to apply the formatting, for example > Greater than.
Enter a value, for example
...
0.
Click the
...
color
...
box and select the color you want to apply if the condition is met, for example
...
red.
Click the
...
Add Rule (plus) button to add another rule line, then repeat the above steps a to e to create another rule. You can add up to three rules.
Ensure the rules display in the correct order. Each rule overwrites the preceding rule. If you want to reorder the rules, click a rule’s Move button, then drag the rule up or down to the new position.
Click Apply. The grid
...
To edit the conditional formatting rule, click the Edit button, make your change and click Apply.
To retain the conditional formatting, save your updated grid view as a favorite or add it to a dashboard.
...
updates, with the color code applied to the selected column. A summary of the conditional formatting rules displays above the grid.
Info |
---|
Notes about the lock feature:
|
Manage rules
If the conditional formatting does not display as expected or you change your requirements, you can update the rules you create.
Click the Edit button, to open conditional formatting edit mode, then proceed as required:
Change the column to which a rule applies.
Change the terms of a rule.
Change the order in which the rules apply.
Remove a rule: Click the Delete button.
Click Apply.
Keep the conditional formatting
To retain the color coding for future reference, either:
When you add the updated grid as a widget on the dashboard, users can hover over the Conditional Formatting buttonto display the rule legend.

Exit out of Conditional Formatting mode
If you are finished applying the conditional formatting and no longer want to see the updated grid, click the Finish Editing button in the toolbar. Your conditional formatting is removed. To reinstate it, you need to add the rules again.
On this page
Table of Contents | ||||
---|---|---|---|---|
|