color statistic table cell dynamically on certain rule using other field value

[Abhineet]

Want to change color of statistic table cell value on certain rule using other field.

TABLE:

Region, Device, Service, Leased License, Reserved License, Maximum License, Current Users

CHINA	AMCDPVPN1	DESKTOP	1700	1700	2000	638
	SCLAMPVPN1		100	100	200	0
Republic Of Korea	AMKDPVPN1	DESKTOP	1000	1000	1300	294
INDIA	AMINDDPVPN1	DESKTOP	2200	1900	2500	2083
SCLA	SCLADPVPN1	DESKTOP	4000	4000	5000	549

"current users" cell should have color as below mentioned rule.

1. RED: if "Current Users" greater than or equal to "Reserved License"

2. YELLOW: if "Current users" greater than  85% of  "Reserved License" and less than "Reserved License" 

3. GREEN: If "Current users" less than  85% of  "Reserved License"

[ITWhisperer]

Make current users a multi-value field with the second value evaluated to the colour you want (dependent on the conditions you mentioned). Then format the field colour based on the colour, and add CSS to hide the second multi-value in the current users column. See my solution to this post https://community.splunk.com/t5/Splunk-Search/How-to-color-the-columns-based-on-previous-column-valu...