Hello Everyone
I currently have an excel sheet that has 96 columns grouped into sets of four.
Each group of four make up a month. MonthsGroup.PNG

I am trying to make it so the group of four that correspond to today's date would have a border of Red instead of just black.
I figure that each group of four could be named as a range (july_2017, aug_2017, sep_2017, etc, etc) and then using a cell that automatically populates with today's date (=TODAY()), an "on open" event could check this date and then using an if statement, set the boarders of the corresponding group to red.

However, VBA syntax has me not even knowing where to start. If there is an easier way to do this- like with conditional formatting for example, I would be more than happy to use that method instead.

Any help woyld be much appreciated.

Thanks