Using checkbox to change cell color

Discussion in 'Excel Beginners' started by Janellec1986, Apr 17, 2014.

  1. Janellec1986

    Janellec1986 Guest

    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!
    Janellec1986, Apr 17, 2014
    1. Advertisements

  2. Janellec1986

    Claus Busch Guest


    Am Thu, 17 Apr 2014 12:45:46 +0100 schrieb Janellec1986:
    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:!326
    for "HighlightCells".
    Rightclick and download the file to see the formula in the Conditional
    Formatting and how this works.

    Claus B.
    Claus Busch, Apr 17, 2014
    1. Advertisements

  3. Janellec1986

    Janellec1986 Guest

    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...
    Janellec1986, Apr 18, 2014
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.