Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

color a cell

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

 

1 Reply
sunny_talwar

May be this

If(Sum({<Qty = {6, 36}>} Lables) - Count({<Qty = {36, 66, 96, 126}>} RxNo) > 28, Yellow())