Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

 

 

You can create rules on report columns and even canvas widgets to highlight or alter data when a match is made on the content. 

For example, you can make it so that if the profits on your monthly report hit a number greater than 500,000, that data will be highlighted with a blue colour.

Rules on Report Columns

While on the Conditional Formatting popup window, you can create rules with different types of styling:

 

Types of Styles

Yellowfin allows users to add three types of styles when rules are matched, as explained below:

Cell

This can be used to highlight the background colour in a matching cell.

Follow these steps:

  1. Choose a column from the left side, on which the formatting will be applied

    Based on the data type of the column, the styling options will differ.

  2. Choose the Basic option from the Alert Type
  3. Select Cell from the Style dropdown
  4. Choose the type of comparison
  5. Click on the +Add Another Rule link; a new pop to format matching cells in the report will appear
    1. Start creating a rule by choosing an operator and then adding a value
    2. Set a style to highlight the matching cells

      IconStyle typeDescription
      BoldTo make the matching values appear bold.
      ItalicMake your values italic with this option.
      UnderlineAdd an underline to the matching values.
      Font colourChange the colour of the font.
      Background colourChange the background colour.

       

       

       

       

    3. Click on the Submit button to save the rule

 

Rules on Widgets

 

 

 

 

  • No labels