Marking a range True or False based on a single Checkbox
 

Is it possible to create a checkbox that will mark a range TRUE or
FALSE depending on the condition of the checkbox? I have a range of
cells i want to mark as true or false dependent on a checkbox in a
form. If you link a checkbox to a range it will only change the first
cell in that range to true or false. Is this just impossible to do?

Or can you maybe approach it from the other side by creating a formula
in the cell such as =IF(CHECKBOX 1 = "TRUE", "TRUE', "FALSE"). I
tried that and it didn't' work but the syntax may be something I'm not
aware of?

Thanks for your help,
Steve

Marking a range True or False based on a single Checkbox
 

assume the range is B5:B10

link B5 to the checkbox

in B6 put in
=B5

drag flll down to B10.

--
Regards,
Tom Ogilvy


"smonczka" wrote:

Is it possible to create a checkbox that will mark a range TRUE or
FALSE depending on the condition of the checkbox? I have a range of
cells i want to mark as true or false dependent on a checkbox in a
form. If you link a checkbox to a range it will only change the first
cell in that range to true or false. Is this just impossible to do?

Or can you maybe approach it from the other side by creating a formula
in the cell such as =IF(CHECKBOX 1 = "TRUE", "TRUE', "FALSE"). I
tried that and it didn't' work but the syntax may be something I'm not
aware of?

Thanks for your help,
Steve

Marking a range True or False based on a single Checkbox
 

Tom, great idea, thanks!

Steve