Unchecking check bow when a reference box is changed.

[Parkerpen13]

I have a list of form control check boxes that I am using to change the color of another cell when the box is checked. What I would like to do is when the box is checked to uncheck the box when a reference or another cell is changed. Is this possible?

 

[Parkerpen13]

I should add that once the check mark is removed I would like it to stay that status until it get manually checked.

 

[Parkerpen13]

So what I am doing is I have my checkboxes in column a and column c I have dates. What I want to do is when the check box is checked it’s for review and when the date next to it in column c is updated to uncheck the box and leave it that way till the box is checked again. Is this possible?

 

[Parkerpen13]

Unchecking check box when a reference box is changed.

I have a list of form control check boxes that I am using to change the color of another cell when the box is checked. What I would like to do is when the box is checked to uncheck the box when a reference or another cell is changed. Is this possible?

 

[My Aswer Is This]

Re: Unchecking check box when a reference box is changed.

Having a lot of check boxes programmed to change a cells color seems like a lot of work but:

Show us the code you have in your checkbox

And when you say:

change the color of ​

another cell

​

And then you say:​

when the box is checked to uncheck the box when a reference or another cell is changed.

​

​

We need to know what cells another cell is vague.

I would suggest we use a sheet change event script which requires no check boxes and just a little bit of code.

Give us specifics like what cell you want colored.

Is it always in the same column?

​

​

​

 

[Parkerpen13]

Re: Unchecking check box when a reference box is changed.

Thanks for the reply. So this is what I am trying to do. I have column A with my check marks. This will be used to flag a name that needs attention. I have column B that is a helper column with the True/False and I have conditioning format to turn the name red when its checked. What I want to do is uncheck and change the True to a False when column C the Coat Wash date is updated. This is feed from another formula.

[TABLE="width: 725"]
<tbody>[TR]
[TD]Wash Request
[/TD]
[TD]Helper
[/TD]
[TD]Assignee
[/TD]
[TD]Coat Wash Date
[/TD]
[TD]Pants Wash Date
[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Brian
[/TD]
[TD]3/18/18 9:16 PM
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Scott
[/TD]
[TD]3/18/18 9:16 PM
[/TD]
[TD]3/18/18 9:16 PM
[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Gerald
[/TD]
[TD][/TD]
[TD]3/18/18 8:48 PM
[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]TRUE
[/TD]
[TD]Barry
[/TD]
[TD]3/18/18 8:48 PM
[/TD]
[TD]3/18/18 8:48 PM
[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Bill
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Bill
[/TD]
[TD]3/18/18 9:16 PM
[/TD]
[TD]3/18/18 9:16 PM
[/TD]
[/TR]
[TR]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD="align: center"]FALSE
[/TD]
[TD]Doug
[/TD]
[TD]3/18/18 8:51 PM
[/TD]
[TD]3/18/18 8:52 PM
[/TD]
[/TR]
</tbody>[/TABLE]