How to add color to cells based on condition?

[smruti13]

Hi,

I have a table as below:

Team Points/week Sprint 1 Sprint 2 Sprint 3 Sprint 4 Sprint 5 Sprint 6

A 18 2 9 3 0 5 5

B 38 16 28.5 0 26 10 8

I need to add color to the sprint fields as per the below condition:

sprint points>=points/week : GREEN
sprint points<90% ponts/week : RED
sprint points>=90% and <100% : AMBER

eg. Sprint1=2 points/week=18, hence color=RED(less than 90%)

Can someone help me achieve this?

[jeffland]

You are probably looking for this.

[niketn]

@smruti13, if you are on Splunk 6.5 or higher this should be built in to Splunk. Refer to Table Formats example in Splunk 6.x Dashboard Examples App.

[smruti13]

Thanks @niketnilay . But I am using splunk 6.4 and I think this can be achieved using javascript. Any idea on that?