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?
@preacher_15 Please refer the below link
https://answers.splunk.com/answers/716468/change-cell-color-based-on-range.html