Forum Discussion

jegarner's avatar
jegarner
Copper Contributor
Oct 07, 2020

TRUE checkbox value auto-populates adjacent cell from another Sheet tab

My spreadsheet has 2-sheet tabs: 'Sheet1' and 'Sheet2'. In 'Sheet2' cell 'A1' there's a checkbox.    If I put a check (True) in the checkbox in 'Sheet2' cell 'A1', is there a way to auto-populate ...
excel
jegarner's avatar
jegarner
Copper Contributor
Oct 07, 2020

Thanks Hans, it worked as you suggested.

 

Is there also a way to change the formula so that if the checkbox is not checked, it displays a '0'?

jegarner's avatar
jegarner
Copper Contributor
Oct 07, 2020

I figured it out by changing the formula to this: =IF(A1,Sheet1!A1,"0")

 

However, when I now try to change the background color with conditional formatting equal to '0', it doesn't work. Not sure why.....

  • jegarner's avatar
    jegarner
    Copper Contributor
    Oct 07, 2020

    HansVogelaar 

     

    I figured it out. I had to change the conditional formatting to text for the 0 and it worked.

    Thanks again for your help with this Hans.

Resources