I'm hoping someone out there has the answer to what I think should be a fairly simple problem.
I'm designing a form for users to fill in, the results will then be used to make a calculation on a separate worksheet.
I have cells formatted in a different colour to indicate that these are the cells that the information is to go in to.
I also have some check boxes (which are linked to cells ie A1)
If a user selects/deselects a check box, I want the shading of other cells to change, therefore indicating that they do or do not need to be completed.
I have been playing with conditional formatting and have got that to work with radio buttons (ie for selecting one of 3 options) but I can't get it to work with check boxes.
I can see in the linked cell that the contents are changing between "TRUE" and "FALSE" however when I use that in a formula it doesn't work.
I have tried using VBA to return the value of the linked cell, either way the value that is returned is Null.
I'm designing a form for users to fill in, the results will then be used to make a calculation on a separate worksheet.
I have cells formatted in a different colour to indicate that these are the cells that the information is to go in to.
I also have some check boxes (which are linked to cells ie A1)
If a user selects/deselects a check box, I want the shading of other cells to change, therefore indicating that they do or do not need to be completed.
I have been playing with conditional formatting and have got that to work with radio buttons (ie for selecting one of 3 options) but I can't get it to work with check boxes.
I can see in the linked cell that the contents are changing between "TRUE" and "FALSE" however when I use that in a formula it doesn't work.
I have tried using VBA to return the value of the linked cell, either way the value that is returned is Null.
