Popular White Paper On This Topic

Even though you specify the range like that, the formula is only looking at one cell from what I see. If you are wanting it to be a true condition if any of the cells between C6 and C44 has a value of Yes, what you might try is to replace the Mooirivier!$C$6:$C$44="Yes" with COUNTIF(Mooirivier!$C$6:$C$44="Yes") >= 1