Name – All global and the user’s personal conditional formats are listed. The active conditional format is selected. Click a name to select a conditional format and review its rules.

Icon, Format, Operator, Value – The rules of the selected conditional format are displayed here.

The Percent of Total Growth conditional format rules in this example are defined as follows:

1.   Display a green up arrow when the measure item value is >=  .0001

2.   Display a yellow horizontal arrow when the measure item value is between .00001 and 0

3.   Display a red down arrow with yellow cell coloring for all other values.

Select or Custom – The Select and Custom buttons switch between the two modes of the window. The Select Conditional Format window has the Custom button available so that you can switch to the Custom Conditional Format window. Click Custom to open the Custom Conditional Format window to define a custom conditional format for the selected measure item. Custom conditional formats are for one time use. They cannot be reused. See Custom Conditional Format window.

OK – Click to save any edits made on this window and close the window.

Cancel – Click to close the window without making any changes.