NColumntable - color formatting - 16.3 Version

I have a requirement where I have to populate the table data from list using HTML template option as we need the specific rows to be colored based on one of the column value in table.

Example : I have students data to be displayed based on the performance column called Grade. That is students with grade
A in color yellow ,students with grade B in orange color and students with grade C in red color.
I want to iterate the list and based on the grade value grouping and coloring needs to be done.
Can we achieve this using user defined template or suggest any other way to do this.? Currently we had implemented using ncolumn and default HTML template.

 

I have tried to achieve this using ncolumntablestyled() , but ill I don't see any color formatting in the table (in email).

Can any one suggest the usage of this function?

 

ncolumntablestyled(

      headerColorHex :"#FF9000",

      baseBkroundHex :"#FF9000",

      stripedBkroundHex :"#FF9000",

      columnHeaders: {

    "License Number",

    "Line Number",

    "Last Producing UWI",

    "Activity Type",

    "Last Production Date",   

    "Date of Non-Compliance",

    "Days to Non-Compliance"

   

  },

ncolumntablestyled(

      headerColorHex :"#FF9000",

      baseBkroundHex :"#FF9000",

      stripedBkroundHex :"#FF9000",

      columnHeaders: {

    "License Number",

    "Line Number",

    "Last Producing UWI",

    "Activity Type",

    "Last Production Date",   

    "Date of Non-Compliance",

    "Days to Non-Compliance"

   

  },

 Discussion posts and replies are publicly visible