You can use conditional formatting for this - no need for any VBA code. With cell from L2 down selected, click on Conditional Formatting | New Rule | Use a Formula ..., and then enter this formula in the dialogue box:

=WEEKDAY(L2,2)>5

Then click the Format button | Fill tab and choose yellow, then OK your way out.

Hope this helps.

Pete