I am looking to monitor Column A8:A400. If the words "WEEKLY Subtotal"
appear in any of these cells I want to change the color for that row
from column A to column J to light blue. If that cell at some point
changes to any other value the color will revert back to default
color.

Can anyone help with this issue?

Thanks for the advice and help!


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=519176