Conditional Formatting Question

[Neil M]

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

 

[Simon Lloyd]

You will have to use VBA to reference the status of the checkbox

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 th
boxes are linked to each cell

What I want is over in cell K15 I want a message to appear if more tha
on
box is checked in that row only. Something simple in bold red lik
"Onl
Check 1 Box

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

Thanks in advance for any hel

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Neil M]

Darn!

It was my understanding that i would only have to do that if I wanted to
lock the other cells/checkboxes.

Oh well, back to the drawing board.

 

[John]

Hi Neil
It can be done, but you need 1 extra columns, first to change true/false into 1
and 0's =IF(A1=TRUE,1,"") then in K15 =IF(B1:B4>1,"Only check 1 box","")
you need to change cell reference to your needs.
HTH
John

 

[Bob Umlas]

=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

 

[John]

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