Conditional Formatting Question
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:B41,"Only check 1 box","")
you need to change cell reference to your needs.
HTH
John
"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
|