@ITWhisperer I was inspired by the your suggestion but instead comparing values from two cells. If n1 is smaller than n2 then color it green otherwise color it red. But it is sometimes setting an incorrect color. Can you help me to identify what I am doing wrong? <dashboard version="1.1"> <label>Colour cells</label> <row> <panel> <table id="tableCellColour"> <search> <query>| makeresults count=10 | eval n1 = (random() % 100) + 1 | eval n2 = (random() % 100) + 1 | eval nn = mvappend(n1, n2) </query> <earliest>@d</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="count">50</option> <option name="dataOverlayMode">none</option> <option name="drilldown">none</option> <option name="percentagesRow">false</option> <option name="refresh.display">progressbar</option> <option name="rowNumbers">false</option> <option name="totalsRow">false</option> <option name="wrap">true</option> <format type="color" field="nn"> <colorPalette type="expression">case(mvindex(value,0) &lt; mvindex(value,1), "#1ce354", 1=1, "#de2121")</colorPalette> </format> </table> </panel> </row> </dashboard>   ... View more