30日間の無料評価版をお試しいただけます。

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Option

Description

Display Style

You can choose how you want the format to be displayed. For example highlight the Cell or insert an icon.

Format

If you have selected 'Icon' display style you will be able to choose from the available icon set below.

Panel
borderColorwhite
bgColorwhite

Traffic Lights

Arrows Up

Arrows Down

Ticks

Shapes

TypeIf you do not wish show the section name or value select Yes and this will remove it from the

reportSelect the comparison type to use with your alert rules.

Panel
borderColorwhite
bgColorwhite

Value

Compares data to set values eg. Greater than 10.

Compare Column

Compares data to set values stored in another column. E.g. Compare the received amount with amount invoiced to highlight those that are not equal.

Percentage of Column

Compares the value to a percentage threshold of a comparison column. Use this to highlight revenue that is 10% less than 'planned revenue'.

Percentage of Total

Compares the value to a percentage of the total of the column. Use this to highlight values that represent less than 5% of revenue.

Percentage of Max

Compares the value to a percentage of the maximum value. Use this to highlight values relative to the maximum value eg. values that are in the lowest 20% bracket of results

Target Column

If you select a column comparison type you will have to choose the column that you want to compare your data to. Choose the appropriate column.

Rule Setting

Once you have selected how you want to highlight your data you must set the rule. The rule input section will differ based on earlier selections. However, generally you will need to choose the colour the operand (greater than etc) and input the values.

...