Be seen. Boost your question’s priority for more expert views and faster solutions
Is There a way for VBA to control conditional formatting?
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
Asked:
3-
3
1 Solution
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
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....
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
Can you specify what rule need to be applied when which check box is activated ?
If it is already specified pls advise where.
gowflow