2 Replies Latest reply on Sep 5, 2013 6:18 AM by Marek Gutowski

    cell colour conditional formatting

    Marek Gutowski

      Hi all,


      I am developing a data quality dashboard. I have a column where difference between expected number of data items and actual data items is calculated.

      I would like to apply a formatting to this column such as if the difference is:

      <=2 then the cell colour is green

      >2 and <=4 cell colour is amber

      > 4 cell colour is red.


      Is there a way to do that. I've seen some posts around conditional formatting such as:



      how would / could i apply those concepts to cell colour and not just value ("font") colour.


      Thanks for your help