Solved

Is There a way for VBA to control conditional formatting?

Posted on 2015-01-29
6
55 Views
Last Modified: 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,$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
Comment
Question by:DougDodge
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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
 
LVL 29

Expert Comment

by:gowflow
Comment Utility
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
 

Author Comment

by:DougDodge
Comment Utility
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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
Comment Utility
I add it Statutory Holidays
gowflow
Rotation-Calendar-V02.xlsm
0
 

Author Closing Comment

by:DougDodge
Comment Utility
Exactly what was needed..... Thank you.
0
 

Author Comment

by:DougDodge
Comment Utility
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

To stay competitive, modern businesses must adapt and stay innovative, and this is increasingly only possible by working with outside talent. Managers and executives have understood the power of outsourcing for quite some time, but traditional clien…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now