How to update table cell color as per the another field?

[rally0321]

Dear all,

I have below table, FieldA (String) FieldB to FieldE (Numeric). Can we base on the FieldA value to change color for FieldB to FieldE?

logic will  below

1. update cell for Field B as red when (FieldA = "1111" or "3333" or "4444") and FieldB cell value >0

2. update cell for Field C as red when (FieldA = "2222" or "3333" ) and FieldC cell value >0

3. update cell for Field D as red when (FieldA = "2222" or "3333" ) and FieldD cell value >0

4. update cell for Field E as red when (FieldA = "4444" ) and FieldE cell value >0

[ITWhisperer · Accepted solution]

Essentially, the technique is to create a multi-value field with a tag for the colour you want to be used, then use format/colorPalette to set the colour and some CSS to hide the extra value in the multi-value field

See this solution https://community.splunk.com/t5/Splunk-Search/How-to-change-table-cell-background-color-depends-on-s...