DougDodge
asked on
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,$
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
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,$
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
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
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
ASKER
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....
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....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what was needed..... Thank you.
ASKER
Can you specify what rule need to be applied when which check box is activated ?
If it is already specified pls advise where.
gowflow