3 Replies Latest reply: Jun 20, 2012 12:53 PM by Raj Vadde RSS

    How to conditionally format empty/null cells in qivot table

      Hi there

       

      I'm trying to do a conditional format where I take the null or empty values and highlight with a particular color.

       

      if

      (IsNull(sum(Units/[Units/Case]), rgb(119,136,153)))

       

       

      didn't work

       

      Your help would be appreciated.