Good job Bob
I knew it could be done but just couldn't figure it out.
It's simple once you see it. need more coffee :)
John
"Bob Umlas" wrote in message
...
=IF(SUMPRODUCT(--E15:H15)1,"ONLY CHECK 1 BOX","")
But it's be easier if you use option buttons - then only one CAN be checked.
You don't need VBA.
Bob Umlas
Excel MVP

"Neil M" wrote in message
...
I am having a problem coming up with a formula for what I want.

I have cells E15, F15, G15 and H15. All of them have checkboxes and the
boxes are linked to each cell.

What I want is over in cell K15 I want a message to appear if more than one
box is checked in that row only. Something simple in bold red like "Only
Check 1 Box"

I get as far as =if(E15)=TRUE..................then I am lost.

Thanks in advance for any help