color a column based on its content using xml code

[ramyaashok]

i have a column status, which will have a message saying "successful" or "unsuccessful",
i want to color the cell green that has successful message
else if unsuccessful color it red.

please help me with the code

[kamlesh_vaghela]

@ramyaashok

    <dashboard>
      <label>Color Cell</label>
      <row>
        <panel>
          <table>
            <search>
              <query>| makeresults | eval status="successful,unsuccessful",status=split(status,",")| mvexpand status</query>
              <earliest>-24h@h</earliest>
              <latest>now</latest>
            </search>
            <option name="drilldown">none</option>
            <format type="color" field="status">
              <colorPalette type="map">{"successful":#00FF00,"unsuccessful":#FF0000}</colorPalette>
            </format>
          </table>
    </panel>
  </row>
</dashboard>

Refer: https://docs.splunk.com/Documentation/Splunk/7.3.1/Viz/TableFormatsXML#Table_format_source_code_exam...