View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
blue49 blue49 is offline
external usenet poster
 
Posts: 2
Default 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