Macro To Highlight Range of a row a Certain Color Depending On Contents In a Cell

I need a Macro To Highlight Cells A Through F Depending On What is In Column C.


For Example If Column C had the Letter D in it I need it to hight light Cells For that Row Yellow. If Column C had the Letter M in it I need it to highlight the Cells Orange from that row.


Highlighting From A Through F is needed. Example File Included Below.

Please Login or Register  to view this content.

Sub Testing()

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

And why use a macro, Excel has conditional Formatting

Please Login or Register  to view this content.

I did it for jen, i cant edit her posts but i reposted the code in the proper #.