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!
Solved
Is There a way for VBA to control conditional formatting?
Posted on 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,$
The conditional formatting is applied as 5 rules against the group above.
Thank you in advance for any help or guidance here....
Rotation-Calendar.xlsm
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,$
The conditional formatting is applied as 5 rules against the group above.
Thank you in advance for any help or guidance here....
Rotation-Calendar.xlsm
[X]
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
6 Comments
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.
gowflow
Can you specify what rule need to be applied when which check box is activated ?
If it is already specified pls advise where.
gowflow
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.
PS
Nice piece of work you have there !!! congrat
gowflow
Rotation-Calendar-V01.xlsm
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.
PS
Nice piece of work you have there !!! congrat
gowflow
Rotation-Calendar-V01.xlsm
Active 1 day ago
Greetings,
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....
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....
Featured Post
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 …
- Document Imaging
- Microsoft Office
- Images and Photos
- Office 365
- Office / Productivity
- Photos / Graphics Software, *Office 2013, *office 2010, *Office 2016, *SharePoint Designer
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.
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
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.