Get Free Trial

How to measure a column and format the color of another column

Ranjith asked on June 16, 2020

How to conditional format one one column and format the color of another column
Right now i can only measure the value of the same column and format the same column I want extend the format to other columns also 
“conditions”: [{
“formula”: “#value < 0”,
“measure” : “Diff”,
“format”: {
“color”: “red”,

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 17, 2020

Hello, Ranjith,
Thank you for your question.
Conditional formatting of the column can be based on the values of another column through specifying its aggregation and uniqueName.
For example, the following code snippet demonstrates the way to format the “Score” hierarchy basing on the “Results” column.

"conditions": [{
"formula": "sum('Results') > 10",
"measure": "Score",
"format": {

Please see an example we have prepared for you.
Our team hopes it helps.
Do not hesitate to contact us in case additional questions appear.
Kind regards,

Please login or Register to Submit Answer