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