Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
gowflowCommented:
I add it Statutory Holidays
gowflow
Rotation-Calendar-V02.xlsm
0
 
DougDodgeAuthor Commented:
Exactly what was needed..... Thank you.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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