Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Is There a way for VBA to control conditional formatting?

Posted on 2015-01-29
Medium Priority
Last Modified: 2015-01-29
I have a workbook with several tabs in it. Specifically worksheet "Yearly".

In each of the cells: Y23, Y24, Y25, AA23, AA24 there is a checkbox. I would like to know how to have the checkboxes turn ON and OFF the conditional formatting being applied to cells: "$A$11:$G$16,$I$11:$O$16,$Q$11:$W$16,$A$20:$G$25,$I$20:$O$25,$Q$20:$W$25,$A$29:$G$34,$I$29:$O$34,$Q$29:$W$34,$A$38:$G$43,$I$38:$O$43,$Q$38:$W$43"

The conditional formatting is applied as 5 rules against the group above.

Thank you in advance for any help or guidance here....
Question by:DougDodge
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 31

Expert Comment

ID: 40577836
ok fine

Can you specify what rule need to be applied when which check box is activated ?
If it is already specified pls advise where.

LVL 31

Expert Comment

ID: 40577884
Is this what you want ?

I noticed nothing for Events built there. But the rest try the check box is this what you want ?

You had holiday and statuary holiday all in the same as no check box for each one separate.

Nice piece of work you have there !!! congrat


Author Comment

ID: 40577964

Events etc. will be a different question..... They are mostly associated with the text being added or not added in worksheets 1 thru 12

You are correct regarding Holidays, I missed that part, there should be a separate checkbox for each (Statutory and Observed should be with separate checkboxes.) If that can be added, this question is done......

All the rest work wonderfully....
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 31

Accepted Solution

gowflow earned 2000 total points
ID: 40578066
I add it Statutory Holidays

Author Closing Comment

ID: 40578257
Exactly what was needed..... Thank you.

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
When asking a question in a forum or creating documentation, screenshots are vital tools that can convey a lot more information and save you and your reader a lot of time
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question