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

  2. Janellec1986

    Claus Busch Guest

    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.
    --
    Vista Ultimate / Windows7
    Office 2007 Ultimate / 2010 Professional
     
    Claus Busch, Apr 17, 2014
    #2
    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...

    Claus Busch;1617029 Wrote:
    > 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 cel

    > 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:
    > http://tinyurl.com/n9s5tdh
    > 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 Professiona



    --
    Janellec1986
     
    Janellec1986, Apr 18, 2014
    #3
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. David H

    cell color change

    David H, Mar 1, 2004, in forum: Excel Beginners
    Replies:
    1
    Views:
    69
    JE McGimpsey
    Mar 1, 2004
  2. *k*
    Replies:
    2
    Views:
    123
  3. niteowl
    Replies:
    1
    Views:
    116
  4. alani

    Cell Change Color - Need Help

    alani, Jun 28, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    118
    Bob Phillips
    Jun 28, 2005
  5. alani

    Cell Change Color - Need Help

    alani, Jun 29, 2005, in forum: Excel Beginners
    Replies:
    1
    Views:
    95
    Bob Phillips
    Jun 29, 2005
  6. Ranger888
    Replies:
    8
    Views:
    110
    Don Guillett
    Mar 10, 2010
  7. John

    CheckBox to change cell color

    John, Jan 18, 2008, in forum: Excel Beginners
    Replies:
    6
    Views:
    104
  8. LeBeauf8331
    Replies:
    1
    Views:
    100
    T. Valko
    Jan 7, 2010
Loading...