You need conditional formatting to do this.

ie formula is =E$4="Yes", then click on format and choose what colour
you want the cell to change to. Then you need to add a condition and
say formula is=E$4="No" and then click on format and choose what colour
you want the cell to chage to. You then need to copy this conditional
format across the cells you want to change colour.

Good luck!


--
Kiwi Girl
------------------------------------------------------------------------
Kiwi Girl's Profile: http://www.excelforum.com/member.php...o&userid=28998
View this thread: http://www.excelforum.com/showthread...hreadid=488119