Conditional formatting in tabular cells using CSS

Hi team,

I am currently building a Canvas workpad and using a Data Table visualization. I’ve successfully constructed the table using Elastic SQL. However, I have two queries regarding the table in Canvas:

  1. Is it possible to apply conditional formatting using CSS? For example, I want values greater than 90 in column 4 to be green and values below 90 to be red.
  2. Is there a way to transpose the table, so columns become rows and vice versa?

Query for CSS which I am trying - <.canvasRenderEl tbody>tr> :nth-child(4){color:green;width:200px;text-align:center;} >

Looking forward to your input.