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

Select A8:J400 with A8 as the active Cell,
do
Format = Conditional Formatting
change Cell Value is to
Formula Is

Put in the formula

=Countif($A8:$J8,"*weekly subtotal*")0

then select format and select pattern and color

then OK your way out.

--
Regards,
Tom Ogivly

"parteegolfer"
wrote in message
news:parteegolfer.247t6m_1141593002.5297@excelforu m-nospam.com...

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

Thanks Tom, This worked out great! :)


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