Excel 2007 : Highlighting Specific Collumns Macro

[shep123]

I am trying to use a macro that will highlight columns E and I of the rows that collumn L equals "XXXXXXX." How can I designate the columns to tie into the row?

Please Login or Register  to view this content.

[rvasquez]

Please Login or Register  to view this content.

Let me know if this works for you

[vandan_tanna]

I think using conditional formatting in this case will be a lot easier than VBA.

I would create conditional formatting using row relative cell reference for columns E and I and then copy it down.

for example for E5: if $L5 = "XXXXXX" then apply conditional format (note missing "$" sign before 5)

[jeffreybrown]

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

[shep123]

Yes that worked. Thanks for the help!