You can use Conditional Formatting.
Select the entire row that you want to fill. Go to FormatConditional
Formatting. Select the Formula is: Option and use this for formatting
red.
=$G3="Fail"
Click on Format and select the color. Ok.
Click Add
For condition 2, use Formula Is
=$G3="Pass"
Click on Format and select the color. Ok.
Click on Ok.
Select the entire row again, click on the Format Painter and apply it
to all the rows you need.
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=499544