Conditional formatting between two cells on the same row

[Unknown]

Hi,I've this grid:I like to do conditional formatting, similar to your examplehttp://asp.syncfusion.com/demos/web/grid/conditionalformatting.aspxBut the condition must be: if greater than the value of the previous column for the same row, then the background must be red.For example, in "09" column, two cells with value grather than 'C09' (same row) column must be render red.But I don't know how get the previous cell value with javascript.Thanks !

[Unknown]

Ok, I tried to formatting my message in edit mode but i can't... 

So, my grid :

And the example : 

[Thavasianand Sankaranarayanan]

Hi Clement, 

Thanks for contacting Syncfusion support. 

Query 1: Need to do conditional format for column based on the previous column values. 

In this query, we suspect that you want to do conditional formatting the Grid columns based on the previous column values. So, we suggest you to use the queryCellInfo event of ejGrid control. In this event we can get the rowData of Grid in the argument. So, based on this we can set the conditional formatting. 

For an example, we have done set the background color for “Value” column based on the “CustomerID” column value. 

Refer the below code example. 

 

<ej:Grid ID="OrdersGrid" runat="server" AllowSorting="true" AllowPaging="True" ClientIDMode="Static"> 

    <ClientSideEvents QueryCellInfo="cellinfo" /> 

            <Columns> 

 

                <ej:Column Field="CustomerID" HeaderText="Customer ID" Width="100" /> 

                <ej:Column Field="Value" HeaderText="Value" Width="100" TextAlign="Right"/> 

                 

            </Columns> 

             

</ej:Grid> 

<script type="text/javascript"> 

        function cellinfo(args) { 

            if (args.column.field == "Value" && (args.rowData["CustomerID"] < args.rowData["Value"]))  

                 

                $(args.cell).css("background-color", "#397218").css("color", "white"); 

             

        }         

    </script> 

We have prepared a sample and it can be downloadable from the below location. 

Sample: http://www.syncfusion.com/downloads/support/forum/131700/ze/SyncfusionASPNETApplication2-1282595109.zip 

Refer the screen shot. 

 

Refer the help documentation. 

Link: https://help.syncfusion.com/api/js/ejgrid#events:querycellinfo 

Query 2: I tried to formatting my message in edit mode but I can't. 

 

In your attached screen shot there is no edit toolbar in Grid. So, what would you expect on this query. 

If we misunderstood your query then please get back to us. 

Regards, 

Thavasianand S. 

[Unknown]

It works very well, thank you.

I just used "args.data.somedataname" instead of "args.rowData ["somedataname"]"

[Thavasianand Sankaranarayanan]

Hi Clement, 

We are happy that the problem has been solved. 

 

Please get back to us if you need any further assistance.  

 

Regards, 

Thavasianand S.