+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting for Multiple Checkboxes

  1. #1
    Registered User
    Join Date
    09-20-2017
    Location
    Philly
    MS-Off Ver
    2003
    Posts
    2

    Conditional Formatting for Multiple Checkboxes

    Hello everyone, thank you for having me!

    I'm fairly new to excel, here's what I'm attempting to accomplish.

    I have about 1128 customers, and for each customer I need to be able to record which out of 4 different documents have been received. My thought was to create a spreadsheet where I can use a checkbox to check off each document as received. I would like for cell that the check box is in to be highlighted when the box is checked. How can I accomplish this? I'm even open to other suggestions to record this information more efficiently in excel.


    Thank you :-)

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Conditional Formatting for Multiple Checkboxes

    You could go either way to achieve your end result.

    You may want to try a VBA code written by one of our Gurus (https://www.excelforum.com/members/9307.html ) - Andy Pope: Set Cell Color Based On CheckBox State | answer #4.

    Which uses an ActiveX Control checkbox and the following code on the sheet

    Please Login or Register  to view this content.
    Or you could try using a Form Control checkbox which is linked to a cell (in this case A1), and use Conditional Formatting
    • Format only cells that contain: Cell Value > Equal to > =TRUE
    • Format: Font > "Pick a color" | Fill > "Pick same color as font"

    See attachment
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-20-2017
    Location
    Philly
    MS-Off Ver
    2003
    Posts
    2

    Re: Conditional Formatting for Multiple Checkboxes

    Thank you Syrkrasi for replying so quickly. I do know how to use the CF function to change the color of the checked box. My question more so is, I don't know how to do that for multiple columns of check boxes, for multiple clients.
    I'm trying to avoid having to format each of these cells one at a time. I've attached a sample of the spreadsheet to give you an idea. There are only 4 clients referenced but there are about 1100, so formatting the cells one at a time would be very time consuming.
    Attached Files Attached Files

+ 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: 1
    Last Post: 12-08-2016, 03:14 PM
  2. Conditional Formatting and Checkboxes are lagging spreadsheet
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-01-2016, 04:07 PM
  3. [SOLVED] Toggle between userform checkboxes for multiple pairs of checkboxes
    By L plates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-25-2016, 06:31 AM
  4. Replies: 5
    Last Post: 12-28-2012, 02:06 PM
  5. Replies: 2
    Last Post: 08-26-2010, 07:46 AM
  6. Conditional Formatting using Checkboxes
    By dagindi in forum Excel General
    Replies: 3
    Last Post: 03-19-2010, 09:38 AM
  7. conditional Formatting using checkboxes
    By macquarl in forum Excel General
    Replies: 1
    Last Post: 12-06-2005, 05:00 PM

Tags for this Thread

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