Conditional Format on Tables

Conditional formatting in tables allows you to apply visual styles to specific rows, columns, or cells based on defined rules. This makes it much easier to highlight patterns, identify trends, and call attention to important data points without manually editing the table.

In Wyn, setting up conditional formatting for tables follows a consistent flow:

1. Select the Table you want to format.

2. Click the Chart (Format) Icon in the toolbar.

3. Click + Add to add a new conditional formatting rule.

When you create a new rule, you’ll see three key settings:

• Set For – What part of the table the rule applies to.

• Based On – The condition that determines when formatting is applied.

• Style – How the data should be visually formatted when the condition is met.

1. Set For

By default, Set For is automatically applied to the first column of the table. However, you can open the dropdown and choose from several options:

• Entire Row – Applies formatting to the entire row if the condition is met.

• Specific Column – Applies formatting only to the column you select. Any column bound to a data attribute will be available here.

This gives you flexibility: for example, you can highlight only sales figures that exceed a threshold, or highlight an entire row when a status column matches a certain value.

2. Based On

The Based On setting determines what kind of rule drives the formatting. There are three options:

a. Field Value

Use the actual values in the selected column to drive formatting.

• Example: Format cells in the “Revenue” column where the value is greater than 1,000,000.

• This option is the most direct, since it looks at the data in the table itself.

b. Another Field

Base the formatting on the values of a different column (not necessarily the one being formatted).

• You’ll need to select the Referenced Field, either by entering it manually or by using the pencil button to pick from available fields.

• Example: Format the “Customer Name” column when the “Status” column equals “Inactive.”

c. Comparison

Create a condition by comparing values. You can compare:

• To a constant value (entered manually).

• To another field in the dataset.

• To a parameter (previously defined in the dashboard).

The available comparison operators are:

• Equal To

• Not Equal To

• Greater Than

• Greater Than or Equal To

• Less Than

• Less Than or Equal To

• Between

• Not Between

This option gives you fine-grained control over formatting rules.

3. Style

Once you’ve defined what should trigger formatting, you decide how it looks. Wyn supports multiple styling approaches:

Option 1: Highlight Cell Rules

Quickly apply rules such as:

• Greater Than…

• Less Than…

• Between…

• Equal To…

• Duplicate Values…

These rules make it easy to call attention to thresholds, ranges, or duplicates.

Option 2: Top/Bottom Rules

Highlight data points that stand out:

• Top 10 Items

• Bottom 10 Items

• Above Average…

• Below Average…

You can also expand these into custom rules for top/bottom N values or deviations from the average.

Option 3: Data Bars

Adds a bar visualization directly into cells, creating an immediate sense of scale.

• Fill Options: Gradient Fill or Solid Fill.

• Minimum/Maximum Values:

  • Automatic

  • Lowest/Highest Value

  • Number

  • Percent

  • Formula

  • Percentile

• Customization:

  • Show Bar Only (hide actual value text).

  • Border (none or solid, with color).

  • Negative Value Handling (choose different fills and borders for negative numbers).

  • Axis Position (automatic, cell midpoint, or none).

This makes it easy to see relative performance at a glance.

Option 4: Color Scales

Applies a gradient of colors based on values.

• 2-Color Scale: Set minimum and maximum with corresponding colors.

• 3-Color Scale: Adds a midpoint (default 50th percentile).

You can define types for each point: Lowest/Highest Value, Number, Percent, Formula, or Percentile.

This option is particularly useful for heatmaps.

Option 5: Icon Sets

Adds small icons in cells based on rules. Categories include:

• Directional (arrows, triangles)

• Shapes (circles, squares, etc.)

• Indicators (traffic lights, flags)

• Ratings (stars, bars)

Icons make qualitative data easier to interpret at a glance.

More Advanced Options

When you select More Rules or New Rule, you get full control:

• Format only cells that contain

  • Apply rules to cells with values, blanks, errors, or specific comparisons.

• Format only top or bottom ranked values

  • Choose how many items are included.

• Format only values that are above or below average

  • Includes standard deviation options.

• Format only unique or duplicate values

  • Highlight uniqueness or repetition.

• Use a formula to determine which cells to format

  • Enter a custom formula for maximum flexibility.

Formatting Options

Once a rule is set, click Format to define exactly how the cells will look. The Format Chart window opens with four tabs:

1. Number

   • Apply number formats: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific.

2. Font

   • Font style: Normal, Italic, Bold, Bold Italic.

   • Effects: Underline, Strikethrough.

   • Size, color, and weight customization.

3. Border

   • Presets: None, Outline, Inside.

   • Individual border control: Top, Bottom, Left, Right.

   • Styles: Solid, Dashed, Double, Thick, etc.

4. Fill

   • Apply background colors or patterns.