1 Reply Latest reply: Aug 15, 2017 11:10 AM by Sunny Talwar RSS

    color a cell

    Robert Winkel

      What is the correct expression to color a cell yellow?


      This is what I have


      if(Count(if(Qty=6, RxNo))>28, Yellow())


      But I need to expand it out like this



      ((Sum(if(Qty=6, Lables)))+(Sum(if(Qty=36, Lables))))-(Count(if(Qty=36, RxNo)))+(Count(if(Qty=66, RxNo)))+(Count(if(Qty=96, RxNo)))+(Count(if(Qty=126, RxNo)))