Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How to customize a cell of one column based on another cell of another column

Juciley de Lima Costa asked on August 30, 2019

Example: If the cell value of one column is 5, the color of another cell in another column changes.

8 answers

Public
Vera Didenko Flexmonster September 2, 2019

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

Public
James November 12, 2019

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

Public
Vera Didenko Flexmonster November 13, 2019

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

Public
James November 14, 2019

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

Public
Vera Didenko Flexmonster November 15, 2019

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

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 17, 2019

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

Public
James December 20, 2019

Hello Illia ,
Thank you for the update. I confirm that everything is working.
 
Best regards,
James

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 20, 2019

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

Please login or Register to Submit Answer