Example: If the cell value of one column is 5, the color of another cell in another column changes.
Hello,
Thank you for writing to us.
At the moment applying conditional formatting to a cell based on another field's value is not supported.
Could you please let us know how critical this feature is for you?
Best Regards,
Vera
Hello Vera,
This feature is a must for us. Do you think it will be developed in the near future?
We have a list of values confronted to a "target" value and i want to higlight them in red when the % between value and target is less than 100 (this percentage is in another column). Unfortunately we can't calculate it during execution as percentage is calculated based on different algorithms for each value.
Best regards,
James
Hello, James,
Thank you for writing to us.
We are glad to inform you that the ability to format the value field based on the condition made on the different value has been added recently.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/ .
For now, you can specify the measure to what you need to apply a condition through the formula
property. The measure
property defines the field you want to format.
Here is the JSFiddle example: http://jsfiddle.net/flexmonster/rqnkbpet/ .
Currently, you can use it only through the API. The UI requires some extensions on your side. The toolbar code is open-source and you can re-use it to support your custom use case. The conditional formatting code is located on the line 1556 (showConditionalFormattingDialog
). We recommend applying your custom view using the customize toolbar approach: https://www.flexmonster.com/doc/customizing-toolbar/ .
Please let us know if you have any questions.
Best Regards,
Vera
Hi Vera,
Thank you for your quick response. We tried adding this feature to our development following your jsfiddle example and it took as while to realise that it doesn't work in case of "Flat form" grid layout option. Can you please fix it in this grid form?
Best regards,
James
Hello, James,
Thank you for your feedback.
You are right, having this feature also available for flat
table sounds reasonable.
Our team will research this further and we will notify you about the results with the ETA 16th of December.
Please let us know if you have any questions.
Best Regards,
Vera
Hello, James,
We are happy to let you know that for the flat form, it is now possible to refer to other measures when defining the conditional formatting rules.
This is provided in the 2.7.21 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component.
Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
The conditional formatting based on the value different from the formatted one can be applied in the same way as for classic and compact forms.
Check out an example we have prepared for you!
Feel free to write to us in case of questions.
Best regards,
Illia
Hello Illia ,
Thank you for the update. I confirm that everything is working.
Best regards,
James
Hello, James,
Our team is happy to hear that everything works fine for you.
You are welcome to contact us if any questions occur.
Best regards,
Illia