Macro Commands

Giganews Newsgroups
Subject: Macro Commands
Posted by:  DanH
Date: Fri, 16 Jun 2006

I need to read through each row in an Excel Worksheet and format it depending
on a code in Col G.  If Code is B then the Cell in Col A must  be bold.  If
the Code is W, then whole row when there is data must be Font Color White and
Fill Color Purple.
I don't  know how to make macro commands read each row at a time until it
reaches the last row and format it accordingly.  I suppose it must be in a
loop.  Can somebody help me?