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
Can you specify what rule need to be applied when which check box is activated ?
If it is already specified pls advise where.
gowflow