Hello,
I've been trying to make a spreadsheet with 55 checkboxes. I need to be able to see quickly which boxes are checked so I wanted to add a macro that changes the color of the field when the box is checked and return it to white when unchecked. (i.e. C2 changes to grey when checkbox in C2 is checked). This seems like a simple script but I seem to be unable to write it. Can anyone help me with this?
Thanks in advance.
I've been trying to make a spreadsheet with 55 checkboxes. I need to be able to see quickly which boxes are checked so I wanted to add a macro that changes the color of the field when the box is checked and return it to white when unchecked. (i.e. C2 changes to grey when checkbox in C2 is checked). This seems like a simple script but I seem to be unable to write it. Can anyone help me with this?
Thanks in advance.