How to Apply color coding to a column based on the condition applied to a different column in the same table?

preacher_15 — Mon, 25 Feb 2019 05:48:06 GMT

Hi All,
I have 3 columns forecast, actuals and percentage. what i need is based on the values of the percentage column i want to apply a condition to it and color the forecast and actuals columns accordingly.
example:
forecast actuals percentage
100 150 1%
300 200 10%

500 400 50%
condition i want to apply is if Percentage is Greater than 1% and less than 10% apply color red to forecast and actuals
if Percentage is Greater than 10% and less than 50% apply color green to forecast and actuals
how can i achieve this using java script and css?

Re: How to Apply color coding to a column based on the condition applied to a different column in the same table?

ashajambagi — Mon, 25 Feb 2019 13:25:18 GMT

@preacher_15 Please refer the below link

https://answers.splunk.com/answers/716468/change-cell-color-based-on-range.html

topic Re: How to Apply color coding to a column based on the condition applied to a different column in the same table? in Dashboards & Visualizations

How to Apply color coding to a column based on the condition applied to a different column in the same table?

Re: How to Apply color coding to a column based on the condition applied to a different column in the same table?