date references in macros
I am trying to set some formatting perameters in a macro for a calendar. I
would like to base the formatting on month. For example, if the month is
January color all the day cells blue, if February red, etc.
I have only been able to get my macro to shade a range and it does it all in
1 color. I am obviously using the wrong language/terms but I can't find info
on how to fix. Suggestions Please.
John
|