I want the formatting to work like this:

If C79 = Y then the cells in E12:E66 turn green


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