User Interface  

Control Elements:

• 

  Conditional Formatting
  Administrates the conditional formatting

  Menu:

  • Apply Formatting Here
    Show conditional formats on selected component
  • Highlights Outliers
    • Color Gradient Red / Green
      Assigns items to one of two groups
    • Color Gradient Red - Amber - Green
    • Color Gradient 3 Steps (Shades of Blue)
    • Color Gradient 3 Steps (Shades of Green)
    • Color Gradient 3 Steps (Shades of Grey)
    • Color Gradient 4 Steps (Red to Blue)
    • Color Gradient 4 Steps (Shades of Blue)
    • Color Gradient 4 Steps (Shades of Green)
    • Color Gradient 4 Steps (Shades of Grey)
    • Color Gradient 5 Steps (Red to Blue)
    • Color Gradient 5 Steps (Shades of Blue)
    • Color Gradient 5 Steps (Shades of Green)
    • Color Gradient 5 Steps (Shades of Grey)
    • Highlight Cells Greater Than...
    • Highlight Cells Less Than...
    • Highlight Cells Between...
    • Highlight Cells Equal To...
    • Highlight Cells Text That Contains...
    • Highlight Top / Bottom Top N Items
    • Highlight Top / Bottom Top N % of Range Total
    • Highlight Top / Bottom Bottom N Items
    • Highlight Top / Bottom Bottom N % of Range Total
    • Highlight Top / Bottom Above Mean
    • Highlight Top / Bottom Above Median
    • Highlight Top / Bottom Below Mean
    • Highlight Top / Bottom Below Median
    • Highlight Top / Bottom Above Upper Quartile
    • Highlight Top / Bottom Below Lower Quartile
    • Highlights Outliers More Than N Std Dev Above Mean
    • Highlights Outliers More Than N Std Dev Below Mean
    • Highlights Outliers More Than 1.5 IQR Above Upper Quartile
    • Highlights Outliers More Than 1.5 IQR Below Lower Quartile
  • Reset
    Removes all format definitions
• 

  Highlight Priority
  Highlights cells that have a priority
• 

  Highlight Knowledge
  Highlights cells according to its knowledge state
• 

  Highlight Conditional Formats
  Shows the colors according to conditional formatting rules