Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
May be this
If(Sum({<Qty = {6, 36}>} Lables) - Count({<Qty = {36, 66, 96, 126}>} RxNo) > 28, Yellow())