Solved

Is There a way for VBA to control conditional formatting?

Posted on 2015-01-29
6
63 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
[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
 
LVL 30

Expert Comment

by:gowflow
ID: 40577836
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 30

Expert Comment

by:gowflow
ID: 40577884
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
ID: 40577964
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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 30

Accepted Solution

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

Author Closing Comment

by:DougDodge
ID: 40578257
Exactly what was needed..... Thank you.
0
 

Author Comment

by:DougDodge
ID: 40579064
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Does Mac Word 2016 have collapsable regions? 8 81
Calculate dates based on if statements in excel 5 38
Excel formula with SUMIF and SUBTOTAL 13 46
Excel - IF criterion 2 24
In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme a…
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

751 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