4 Replies Latest reply on Jul 12, 2012 4:46 PM by Cody Smith

    Conditional formatting null cells

    Cody Smith

      I've been trying to do a conditional format like in excel that will fill all NULL values with a solid red, but to no avail.


      I tried using the follow calculated field:


      IIF(ISNULL(SUM([$ Sales])),"Red","Green")


      The "Green" part works, but it will not fill the NULL cells with red.


      Attached is an example of what I'm trying to accomplish, except where all white areas will be red eventually.