View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
viewmaster[_5_] viewmaster[_5_] is offline
external usenet poster
 
Posts: 1
Default Changing cell colour in Range


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