Do the cells B2 - H2 have to be merged?

This formula works on unmerged cells, {=IF(N5:N9="no","message","")}

merged cells don't like array formulas.

Best I can do I'm afraid, perhaps a real expert can help...........


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=491466