+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting for Multiple ActiveX Controls

  1. #1
    Registered User
    Join Date
    07-21-2014
    Location
    Toronto, ON
    MS-Off Ver
    MS Office 2010
    Posts
    55

    Conditional Formatting for Multiple ActiveX Controls

    Good Morning. Here is what I am looking to do, I hope someone can help me!: I have a workbook with multiple sheets. I want to add conditional formatting for a cell on 1 worksheet based on if multiple ActiveX controls are checked (checkboxes) on another sheet. I have 10 checkboxes (now LinkedCells named "G1" -> "G10") on worksheet "Data Entry". The formula should be if all 10 boxes are checked on the "Data Entry" worksheet, cell "A1" on the "Milestone" will be gray. Any clues on how to write the formula for this Conditional Format? Thank you.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Conditional Formatting for Multiple ActiveX Controls

    Try

    Conditional Formatting
    New Rule
    Use a formula to determine. . .

    =(COUNTA(G1:G10)=10)

    COUNTA counts non empty cells
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Conditional Formatting with Form Controls. I'm stumped
    By DAC_LCS in forum Excel General
    Replies: 2
    Last Post: 05-24-2012, 11:03 AM
  2. ActiveX controls
    By ell123 in forum Excel General
    Replies: 1
    Last Post: 08-21-2009, 12:10 PM
  3. Form controls vs. ActiveX controls
    By wmorrison49 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2008, 10:59 AM
  4. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 AM
  5. [SOLVED] activex controls
    By Gary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2005, 06:12 AM

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