Using checkbox to change cell color

[Janellec1986]

Hello. I am very new to excel. At work, I was tasked with creating
checklist that when you click the check box, the cell turns green.
have absolutely NO clue how to do this. If someone could explain thi
to me in detail (again, I don't understand excel jargon) I would greatl
appreciate it.

Heres an example:

Cell A2-E2 states: Account for all non-essential personnel.
The check box is in cell A2.
When I click the check box, I would like the cells where the text i
(A2-E2) to highlight green. I have approximately 50 checkboxes in m
spreadsheet and I'm assuming if I learn how to do the first one, th
rest will be the same with the exception of changing the cell numbers.

Thanks in advance!

 

[Claus Busch]

Hi,

Am Thu, 17 Apr 2014 12:45:46 +0100 schrieb Janellec1986:

Cell A2-E2 states: Account for all non-essential personnel.
The check box is in cell A2.
When I click the check box, I would like the cells where the text is
(A2-E2) to highlight green. I have approximately 50 checkboxes in my
spreadsheet and I'm assuming if I learn how to do the first one, the
rest will be the same with the exception of changing the cell numbers.

I would not put 50 checkboxes into a sheet. If you filter the data the
checkboxes don't stay in place.
Make a helper column and format as "Webdings" and write a "a" in it or
delete it. You can highlight the cells then with Conditional Fotmatting
Please have a look:
https://onedrive.live.com/?cid=9378...#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for "HighlightCells".
Rightclick and download the file to see the formula in the Conditional
Formatting and how this works.


Regards
Claus B.

 

[Janellec1986]

Nothing needs to be filtered. Its one page of "to-do" items, if yo
will. My boss wants a checklist where if you click the box, the tas
turns green (complete). I don't understand the helper column at al
since, as I mentioned in my original post, I am very new to this.
breakdown or step-by-step would be extremely helpful...