DATA Table ... How to change the Color of cell as per the Cell Value Of Table

debugcn Published at Dev

AKVYAS23

I am using Datatable Concept but don't know how to change the the color of a cell as per the cell value. I know How to change the entire row's color as per the cell value .. Here is the code which I am using for row .. Where should I change the code ...??

$('#example').DataTable( {
                //"bDestroy": true, // NOT Working THis Function Here ...!!! 
                dom: 'Bfrtip',
                buttons: ['copy', 'csv', 'excel', 'pdf', 'print'],
                retrieve: true,
                //FOR COLOR CODING AS PER THE VALUES in THe ROW/ CELL..!!!-NOW IT is for the Entire Row .. !!
                "fnRowCallback": function( nRow, myInfraArray)
                {
                            if ( myInfraArray[3] == "" )
                            {
                                $('td', nRow).css('background-color', '#F08080');
                            }
                            else if ( myInfraArray[3] == "Not Availiable" )
                            {
                                $('td', nRow).css('background-color', '#F08080');
                            }
                            else if ( myInfraArray[3] >= 5 && myInfraArray[3] <= 15)
                            {
                                $('td', nRow).css('background-color', '#90EE90');
                            }
                            else if (myInfraArray[3] >= 0 && myInfraArray[3] <= 4 )
                            {
                                $('td', nRow).css('background-color', '#FFDAB9');
                            }

                        }
                    } );

AKVYAS23

I have solved IT ... :) Here Is the Code For change the color of a cell as per the cell value...

     $('#example').DataTable( {
                        //"bDestroy": true, // NOT Working THis Function Here ...!!! 
                        dom: 'Bfrtip',
                        buttons: ['copy', 'csv', 'excel', 'pdf', 'print'],
                        retrieve: true,
                        //FOR COLOR CODING AS PER THE VALUES in THe ROW/ CELL..!!!-NOW IT is for the Entire Row .. !!
                        "fnRowCallback": function( nRow, myInfraArray)
                        {
                                      $(nRow).children().each(function(index, td, myInfraArray) {     
                                        if ($(td).html() == "") {
                                              $(td).css("background-color", "#F08080");
                                           } else if ($(td).html() == "Not Available") {
                                              $(td).css("background-color", "#F08080");
                                           } else if (($(td).html() >= 5 && $(td).html() <= 20)) 
{  $(td).css("background-color", "#90EE90");
                                           } else if (($(td).html() >= 00 && $(td).html() <= 4) || ($(td).html()=="not working"))
     $(td).css("background-color", "#FF3229");
                                    $('table:last tr:nth-child(2) td:nth-child(2)').
                                    css("background-color", "#cccccc");
                                } );
                                return nRow;
                                }
                            } );

Collected from the Internet

Please contact [email protected] to delete if infringement.