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)))