+ Reply to Thread
Results 1 to 4 of 4

Grey shading to row when checkbox unchecked

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    Hervey Bay, Queensland
    MS-Off Ver
    2010
    Posts
    2

    Grey shading to row when checkbox unchecked

    Hi,

    I'm creating a cost calculator sheet with a list of items that can be checked or unchecked. I am very new to VBA and am wondering how I get a row to shade grey or be "ghosted" when the checkbox for that row is unchecked. I want the background colour of the row to be light green when checked then grey when unchecked.
    I know it can be done as I have a copy of a calculator done by someone else and this is what happens on theirs but its locked with a password so I can't see how they have done it.

    I have attached a copy of my file (COPY Preliminary Cost Calculator). I have also attached the copy file (Copy of final_quotationcalculatorv2only21092009)I have which shows what I'm trying to achieve with the grey shading.

    Thanks in advance
    Last edited by Allycat84; 05-12-2015 at 09:22 PM. Reason: Additional Information

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    365 Version 2505
    Posts
    2,790

    Re: Grey shading to row when checkbox unchecked

    I don't know if there's an easier way to do this, but I got it to work by writing code for every button. If you are going to add a bunch more buttons I don't know if I can help you.

    If your original request is fulfilled please click the Thread Tools drop down box above your first post and choose solved.

    If you are happy with my help, please consider clicking the add reputation button in the lower left hand corner of this post.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    08-22-2011
    Location
    Auckland
    MS-Off Ver
    Excel 2019
    Posts
    716

    Re: Grey shading to row when checkbox unchecked

    Hi Alleycat84
    The copy of final workbook you posted does the cell shading with conditional formatting. It's looking for a true or false value in column L or M

    Select one of the coloured cells & have a look at the formula in conditional formatting\manage rules & double click the rule to see it in full

  4. #4
    Registered User
    Join Date
    05-12-2015
    Location
    Hervey Bay, Queensland
    MS-Off Ver
    2010
    Posts
    2

    Re: Grey shading to row when checkbox unchecked

    Thank you, I managed to do it using the conditional formatting.

+ 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. [SOLVED] Remove data when checkbox is unchecked
    By matrixpom in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 10:13 PM
  2. Checkbox When Unchecked Hides Worksheet
    By dcarn in forum Excel General
    Replies: 1
    Last Post: 12-06-2012, 06:57 PM
  3. [SOLVED] How do I change a checkbox to unchecked without running the code within the checkbox
    By jsunnb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2012, 09:28 PM
  4. Unchecked listbox using checkbox OLEObject
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-18-2012, 11:49 PM
  5. calculate checked and unchecked of checkbox
    By laici in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-03-2009, 02:12 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