I imagine this is a pretty simple piece of VBA programming.

I want Excel to automatically highlight a row when I select a cell
from that row. For example, if I select G20, I want row 20 to be
highlighted, say, in yellow.

I'm using Excel 2007 and Windows XP if it matters.

Thanks for the help.