Cell C8 does not exist in its own right. It's merged with cell B8 ... so it's not going to have a value and all the conditions fail.


Regards, TMS