Macro to Fill Cells with H if it is a Friday or a Saturday

Hello All,
I am using Excel 2010.

I have many sheets about 30+ (Sample data attached)
Data is in B14:AF25 - see bordered area
I want a macro which should run on all the Sheets and put H for dates falling on Fridays and Saturdays for all months in the current year

It should put H in green color in Cells which are Fridays and Saturdays (Highlighted for month of August only)

If the month is 28 days eg Feb then it should fill the cells 29, 30 and 31 with Red Color
It should fill Red in the Cells according to the days in a month - Filled Red in the sample

Any help would be appreciated
TIA
Rashid Khan

Hi

You'll need to use WEEKDAY for this, it will return the day of the week as a number, then you can do the Friday and Saturday thing.

I'd use formula based conditional formatting for your extra days past 28th or 30th, also you are not doing the 29th Feb every year, so this would be better to calculate the last day, EOMONTH

There will be a load of articles on the net for looping through worksheets and looping through cells.

Cheers

Google it, sorry, this will explain how to do what you want.