Format Cells With a Two-Color Scale

In this guide, we’ll walk through how to apply a two-color scale to the Total Sales Amount column.

Step 1: Select the Table

1. In your Wyn dashboard, select the table you want to format.

2. Once selected, the action buttons appear on the right-hand side.

Step 2: Open Conditional Formatting

1. Click the Conditional Formatting button from the action menu.

2. The Conditional Formatting window will open.

Step 3: Configure the Rule

1. Under Set For, select Total Sales Amount.

2. Leave Based On set to Field Value.

3. Open the dropdown for Style.

   • Select Color Scales.

4. Choose a Two-Color Scale option from the list.

5. Click OK to apply the formatting.

Example: Using a Two-Color Scale on Sales Amounts

Here’s a sample query you can use against the AdventureWorksDW database to get a dataset with varied sales amounts:

SELECT TOP 20
    p.ProductKey,
    p.EnglishProductName AS ProductName,
    SUM(f.SalesAmount) AS TotalSalesAmount,
    SUM(f.OrderQuantity) AS TotalQuantity
FROM
    FactResellerSales AS f
JOIN
    DimProduct AS p ON f.ProductKey = p.ProductKey
JOIN
    DimDate AS d ON f.OrderDateKey = d.DateKey
WHERE
    d.CalendarYear = 2013
GROUP BY
    p.ProductKey,
    p.EnglishProductName
ORDER BY
    TotalSalesAmount DESC;

And this is the table with the conditional formatting applied: