Hi all,

I am looking to see if anybody can help me create a macro that will format cells according to dates in my PC's internal calendar. I would like to add a button to my spreadsheet that will update the formats when clicked. I would like my macro to follow this rule set:

If date falls on first or second Saturday of month, color yellow (unless the first Saturday is the 1st of month)
If date falls on third Saturday of month, color gray (unless first Saturday of month was the 1st, then go to 4th Saturday)
If date falls on the 1st of the month, color orange

I will be applying these rules to dates in various months all the way out to December 2015. Because my knowledge of VBA is very basic at this point, I'm not sure how to get started with this or if it is even feasible. If not, I have alternative ideas as to how to make this macro. I would greatly appreciate any help/input in putting this together. Thanks.