Conditional Formatting for Fields Within Hierarchy

In the attached image, I would like to use the SyncFusion grid to create both a hierarchy as well as apply conditional formatting at certain levels of the hierarchy.

I am trying to create a resource list which can display a list of people, the list of projects each person is working on, and the amount of planned time they will work on each project. I want to aggregate this data and the apply conditional formatting based on whether the planned time is above or below a certain threshold.

How could we do this with SyncFusion?

Thank you.

Tim

Attachment: Capacity_Planning__Portfolio_Example_588be7fa.zip

1 Reply 1 reply marked as answer

AG Ajith Govarthan Syncfusion Team September 7, 2020 02:08 PM UTC

Hi Tim, 

Thanks for contacting Syncfusion support. 

We checked the attached screenshot and found that you have applied the conditional formatting for the aggregate data.  

Based on your screenshot architecture we suspect that it is related to the EJ2 TreeGrid Component and also you want to set the conditional formatting for the aggregated rows which is shown in the screenshot. In this we also noticed that the aggregates are shown at the middle of the rows.  

So before we proceed to your query we have shared the sample browser links  and documentation links so please refer the attached sample browser and  documentation confirm that which behavior you need to require at your end.  

SB-Link Tree Grid: 

UG-Link Tree Grid: 

SB-Link Grid: 
UG-Link Grid:  

Please share the dataSource architecture which you are going to bind to the Syncfusion EJ2 Grid or EJ2 TreeGrid component. 

Regards, 
Ajith G. 






Marked as answer
Loader.
Up arrow icon