• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 74
  • Last Modified:

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,$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....
Rotation-Calendar.xlsm
0
DougDodge
Asked:
DougDodge
  • 3
  • 3
1 Solution
 
gowflowCommented:
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
0
 
gowflowCommented:
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
0
 
DougDodgeAuthor Commented:
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....
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
gowflowCommented:
I add it Statutory Holidays
gowflow
Rotation-Calendar-V02.xlsm
0
 
DougDodgeAuthor Commented:
Exactly what was needed..... Thank you.
0
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

Featured Post

Free Tool: Path Explorer

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now