How to color cells based on there values and bases on the cells before it?

[robertlynch2020]

Hi

I have lots of data that I want to see on one screen, so I need to use a transpose.

When I do this I cant add colours easily

As you can see below this is what I want.

when the % is over 100 it goes red and below 100 it goes green, but only for the columns with % in then.

Any help would is great thanks.

[robertlynch2020]

Hi

IN the end i used this answer to get me where i needed to go.

https://community.splunk.com/t5/Dashboards-Visualizations/How-to-change-font-color-based-on-a-condit...

[ITWhisperer · Accepted solution]

You can also do this with CSS (no javascript)

https://community.splunk.com/t5/Dashboards-Visualizations/Highlight-row-if-unique-values-exist-withi... 

Essentially, you extend the fields you want coloured with a multivalue representing the colour you want, use colour palette to convert the value to a colour and use CSS to hide the additional multivalue.

[robertlynch2020]

Hi

This for the answer. 

I used this one and yours to get me there.

https://community.splunk.com/t5/Dashboards-Visualizations/How-to-change-font-color-based-on-a-condit...

[mayurr98]

Pls refer this:

https://community.splunk.com/t5/Dashboards-Visualizations/How-can-I-get-the-Table-cell-colorization-....