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