+ Reply to Thread
Results 1 to 3 of 3

How use checkbox for conditional formating cells

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Lima,Peru
    MS-Off Ver
    2016
    Posts
    25

    How use checkbox for conditional formating cells

    Hello Masters of Macros Excel VBA.
    I need your advice.
    I have this code for conditional formating cells and font

    Please Login or Register  to view this content.
    And this other code for clean all the formating:

    Please Login or Register  to view this content.
    Then I need ADAPT this code for CHECKBOXING
    in the way the when I check the box --- work the coditional formating code and paint cells and change color font.
    when I uncheck the box --- delete all conditional formating.
    I can use a button of course, but CheckBox is more practical.

    If you can guide me how ADAPT this two parts of code with a same checkboxing I will be grateful.

    Thanks for your precious time. I am sharing excel file for you can work directly in the code. CALENDARIO -forum.xlsm

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: How use checkbox for conditional formating cells

    I've used your code in attached file. Check vba and checkbox in col BG (and especially cell BG1)
    Attached Files Attached Files
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Lima,Peru
    MS-Off Ver
    2016
    Posts
    25

    Re: How use checkbox for conditional formating cells

    Thanks for you quickly answer. I like so much the modifications in the code.

+ 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] Conditional Formating with Checkbox
    By Shinra14 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  2. Conditional Formating with Checkbox
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  3. Conditional Formating with Checkbox
    By Biff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  4. Conditional Formating with Checkbox
    By Biff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. Conditional Formating with Checkbox
    By Shinra14 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. [SOLVED] Conditional Formating with Checkbox
    By Shinra14 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Conditional Formating with Checkbox
    By Shinra14 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. [SOLVED] Conditional Formating with Checkbox
    By Shinra14 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-20-2005, 08:05 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