You can't change  the colour of a row  in one go. You'll need to do it for
each cell.

That said, you can select as many cells as you wish, and do them all in one
go.

- select the cells
- Alt-O, D (of Format / Conditional Formatting
- first drop-down to "Formula Is"
- type the formula =$a45="PASS"
- click Format...
- Patterns
- select a colour you like and click OK
- OK again

I used row 45, you can use whatever row you prefer. Then select the area
again and

- Copy
- select the whole area that is to do this (i.e. all the rows and all the
columns)
- Paste Special / Formats

The easiest way to implement that is using Conditional Formatting. It does
not require VBA, it is built in to Excel. The way to do this differs
depending on the version of Office you have.

Note that Excel 2003 allows 3 "layers" of conditional formatting.
Excel 2007 allows a bunch more and also different types of formatting
(icons, gradients, etc). Interestingly I think I found a glitch it
the system. I have my 2007 set to always save in 2003 format by
default. I created a .xls with formatting that SHOULD have work fine
in 2003, but when I emailed it to 2003-users at work the formatting
didn't work.... Just something to keep in mind. If you're using
2007, but sharing your spreadsheets with 2003 users, then makes sure
your setup is even going to work before you spend much time on it...