How to color code cells based on range of another field?

[russell120]

Hi, please consider this example panel within my dashboard:

ticketID    due_date   days_remaining
ticket1    07/20/2019      19
ticket2    08/20/2019      49
ticket3    09/20/2019      79

I know I can color the days_remaining field using the UI, but my quesition is: how do I color cells under due_date based on the range the corresponding days_remainingfield values are within? The range conditions are 0-30 is red, 31-60 is yellow, and 61-90 is green.

With the example panel above, 07/20/2019 should be red, 08/20/2019 should be yellow, and 09/20/2019 should be green.

Note: I'm a Power User at work so I don't have access to .conf files. Can I achieve my solution using xml? Or maybe JavaScript (if I even have access).

[vnravikumar]

Hi

Check this solution which is similar

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

and

https://answers.splunk.com/answers/661894/how-to-color-cell-contents-with-css-and-js.html#answer-661...

[russell120]

Hi, both of your provided links require that I have access to Splunk directories. As mentioned in my initial post, I'm only a Power User. I don't have access to Splunk directories unfortunately.