Good afternoon everyone.

I'm currently building a new order form using Excel at work and I have a front sheet which has three cells, each with a checkbox.
Each tab corresponds to a tab on the form - each for different products. If the customer enters any value into a cell within specified ranges on one of the tabs, the frontsheet has a formula in which tells it to check the box to show order entry which tab has had information added.


The issue I'm having is that some of the selections on the tabs are checkboxes and I've noticed that if the customer ticks a box and then unchecks it, it leaves FALSE in the linked cell and the checkbox on the front sheet thinks that this is customer input so remains checked.

How do I stop Excel from displaying either TRUE or FALSE in the linked cell, thereby not providing my checkboxes on the front with spurious data? I want the customer to be able to tick the boxes where appropriate to select the correct product configuration they require but if they then uncheck the box because they ticked it by mistake, I want it to not affect the =IF(OR(NOT(ISBLANK formula on the front page.

1.png2.png