+ Reply to Thread
Results 1 to 4 of 4

Check box affecting cell

  1. #1
    Registered User
    Join Date
    07-13-2015
    Location
    United States
    MS-Off Ver
    2003
    Posts
    54

    Check box affecting cell

    I'd like to make a checkbox that changes the color of the cell it's in (or on). How do I do that?

    Attached is an example. I'd like checkboxes in the space to the left of the text for the examples and Item #104, and I'd like the checkboxes to change the cell color to green if they're checked.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,760

    Re: Check box affecting cell

    I don't see any checkboxes in your worksheet


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    02-04-2012
    Location
    Belgium
    MS-Off Ver
    Excel 2013
    Posts
    190

    Re: Check box affecting cell

    try this double-click in in a cel of column B its change to yellow colour, double-click again in yellow cel colour is blank
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-13-2015
    Location
    United States
    MS-Off Ver
    2003
    Posts
    54

    Re: Check box affecting cell

    Thanks for the replies. I'd like checkboxes and a green color in the cell when checked. Sixthsense, I don't know how to make checkboxes! Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 06-27-2015, 03:21 PM
  2. [SOLVED] Cell Formatting affecting formulas
    By JakeMann in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-06-2013, 04:52 AM
  3. Blank cell on spreadsheet affecting chart, HELP!
    By Alinkowski in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-28-2013, 04:06 PM
  4. Move every Nth cell up without affecting the rest of the columns.
    By Henk Stander in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2012, 08:09 AM
  5. Conditional Values affecting another Cell
    By dlenoxx in forum Excel General
    Replies: 2
    Last Post: 03-06-2009, 03:59 PM
  6. Replies: 1
    Last Post: 01-21-2006, 12:30 PM
  7. Preventing a Filter from affecting cell shading
    By guilbj2 in forum Excel General
    Replies: 8
    Last Post: 05-30-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1