Create a Macro in Excel 2010 and older

the macro should produce the shading rows of the active worksheet according to the following rules:

Red:
lines are selected that have the values in column F (not empty,