Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Course Of The Month
8 days, 5 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
Active today
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
Active today
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 5 days 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
Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Gain an elementary understanding of Blockchain technology.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the
Monte Carlo …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 5 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.