Highlight cells E12:E66 then go to Format-Conditional Formatting then
choose "Formula is" and write:

=$C$79="Y"

Then click the format button next to the sample text and choose
Patterns and then whatever color you want (in this case, green) and
click OK, and that should be it.

Let me know if it works out.


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=390141