Use case 

You need to choose a lighter status color.

Solution

  1. Switch the page to the edit mode.
  2. Insert the Status macro and paste the table or the macros outputting tables within the macro body.
  3. Select the macro and click Edit.
  4. In the Presets tab select Custom transformation and click Next.

  5. Enter the following SQL query:

    SELECT *,
CASE
WHEN 'Employees' < 60
THEN FORMATWIKI("{status:colour=Green|subtle=true|title=Low}")
WHEN 'Employees' >= 60 AND 'Employees' < 150
THEN FORMATWIKI("{status:colour=Yellow|subtle=true|title=Medium}")
ELSE FORMATWIKI("{status:colour=Red|subtle=true|title=High}")
END AS 'Status'
FROM T1
    SQL
  6. Click Next. 
  7. Define the table settings and view options if needed. 

  8. Save the macro and the page.