»No topics above this level«

Creating Cell Conditions

 Print this Topic Return to chapter overview

Cell Conditions allow you to define the display behavior of a cell based on the cell's value, and are defined per column.  You can choose to alter both the color and text of a cell with Cell Conditions.

 

Creating Cell Conditions

To create a Cell Condition:

 

1.Open the Columns window
2.Select the column you would like to create a Cell Condition for in the applied column section.
3.Under the Special parameters section select Cell conditions and then press the "..." button

 

Market_Analyzer_CreatingCellConditions_1

 

4.Press the New button to add a new Cell Condition to the list of Cell Conditions displayed in the left side of the Cell Conditions window
5.Set the Cell Condition properties in the right side of the Cell Conditions window

 

Market_Analyzer_CreatingCellConditions_2

 

 

The example Cell Condition in the above image will:

 

•Trigger once the cell value is greater than 30
•Display a lime green background with white text
•Display "Greater than 30" as the text

 

You can remove a Cell Condition by pressing the Remove button.

 

Multiple Cell Conditions

Cell Conditions are evaluated from top to bottom.

 

Assume you have the following conditions defined:

 

Change cell if value is greater than 30
Change cell if value is greater than 100

 

In this example, if the value of the cell was greater than 100, the first condition of "greater than 30" would change the cell's color since its first in the list of conditions to be evaluated. The "greater than 100" condition would never trigger in this example since "greater than 30" will always trigger the color change first. To ensure that both conditions trigger a color change so that you get the desired alerting behavior you want, you have to list the conditions in this order:

 

Alert if value is greater than 100
Alert if value is greater than 30

 

This will guarantee that a cell value over 100 will fall in the "greater than 100" condition and cell values between 30 and 100 will be triggered by the "greater than 30" condition.