Highlight the range you want the formatting to apply to.
Select Format Conditional Formatting
Select Formula is
Enter =$E1="yes" (assuming your range starts in row 1)
Click on Format
Select your green background fill
OK you way out


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=483992