asked on September 11, 2016
Our customer is looking for ability to use conditional formatting not just on numbers but text fields. I tried this but it does not seem to work
⋅ September 12, 2016
Hello Kevin,
Thank you for your question. Unfortunately, there is no such feature in the component and there are no plans on adding it in the next version. Please let us know how critical it is for you.
Best regards,
Dmytro.
⋅ September 12, 2016
It was the first thing our customer asked for as their "other" tools do this. I would say grouping with totals in flat view would sightly be higher priority
⋅ September 12, 2016
Hello Kevin,
Thank you for your response. We have added your request about conditional formatting for the text fields to the customer's wish list.
Best regards,
Dmytro.
⋅ February 23, 2017
Hello Dmytro Zvazhii
Do you have any estimated release date of this feature? I have same issue as "simple"
Also, For a given a row, will it be possible to conditional formatting a column, depending on another column
i.e. For a given row - change background colour of column A depending on value of column B?
⋅ February 24, 2017
Hello Sengupta,
Thank you for your question. I am afraid I cannot provide you with an estimated timeframe right now. However, we have added the feature "Add conditional formatting of column A depending on a value of column B" to the customer’s wish list, as well as "Conditional formatting on text fields". We will take these features into account when discussing future Flexmonster improvements.
Regards,
Tanya
⋅ April 14, 2020
Hello Tanya,
Is there any update on this feature? I'm looking for the same functionality. For example, if the value in column "A" is greater than the value in column "B" than red, otherwise green.
⋅ April 15, 2020
Hi Scott,
Thank you for posting your question.
It seems like in your data you are using regular numeric values instead of string values. In this case, the desired behavior can be achieved with the already existing conditional format functionality.
To highlight cells with a specific color based on their value's comparison with other numeric values, you will simply need to define the corresponding array of Conditional Format Objects in your report configurations:
report: {
dataSource: {
data: getData()
},
conditions: [
{
"formula": "sum('Actual') = sum('Forecast')",
"measure": "Category",
"format": {
"backgroundColor": "#ffd942"
}
},
...
...
We've prepared a quick JSFIddle example to illustrate the mentioned approach: https://jsfiddle.net/flexmonster/9hru6dxq/
Also, you can find more info on conditional formatting in Flexmonster by the following link: https://www.flexmonster.com/doc/conditional-formatting/
Please let us know if this helps.
Best regards,
Mykhailo