Good Morning,
I have a variable row of cells (usually 8-12, but as long as 25). I just want a check that every cell that has a value in it has a value larger than 5.

I started with =IF(AND(G12:O12=5),"Yes","No"), but if any cell is blank this doesn't work.

How can I apply this to only cells within that range which have data entered?

Thanks,
Phillip