Aww, Peco beat me to it. If you want to do it with VBA it's easy, but he's right, you should be able to do it with conditional formatting too.

If you still want to write a macro to do it, or if you already have a VBA program and you want to teach it to do something to the entire row, you just need the EntireRow property of the date cell.