Using checkbox to change cell color
 

Hello. I am very new to excel. At work, I was tasked with creating a checklist that when you click the check box, the cell turns green. I have absolutely NO clue how to do this. If someone could explain this to me in detail (again, I don't understand excel jargon) I would greatly 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 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.

Thanks in advance!!

Using checkbox to change cell color
 

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=9378A...121822A3%21326
for "HighlightCells".
Rightclick and download the file to see the formula in the Conditional
Formatting and how this works.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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