Solved

Is There a way for VBA to control conditional formatting?

Posted on 2015-01-29
6
57 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
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 29

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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 29

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MIgrating Office Settings 2010>365 4 30
Excel Formula Needed 2 44
Excel 2010 Slicer Issue 3 50
Excel 2010 - Formula to show Max of values 11 62
Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

910 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

23 Experts available now in Live!

Get 1:1 Help Now