Hi Tom,
Thanks again for your help! The only problem is that cell in the same
row doesnt change colour another cell changes. For example, if all the
cells in row G12:S12 have "N/A" or a date, F12 is supposed to change
green, however F7 changes. This happens with all the other rows also.
Thanks sooo much for your help!!
--
viewmaster
------------------------------------------------------------------------
viewmaster's Profile:
http://www.excelforum.com/member.php...o&userid=32094
View this thread:
http://www.excelforum.com/showthread...hreadid=519227