How to alter this code to work

[vpan]

Hi all,

I have 2 sheets, CLients and Equity. In CLients I have a list in Col A. I want any of the cells in ColK onwards in Sheet Equity, if they are contained in the list in Col A, to change their background.

The code I have works only for the first match in Equity for each cell in Col A of CLients, how can I apply it to all matches in Equity?

Please Login or Register  to view this content.

[vpan]

Nevermind, I have fixed this myself.
Realized I should loop the otherway around.

This code works now

Please Login or Register  to view this content.

[6StringJazzer]

First, I would be doing this with Conditional Formatting instead of code. When an Excel feature does exactly what you want, there are a few reasons to use it instead of a custom code solution.

Try this. I don't have your file so I can't test it. If you attach your file I would be happy to try it out.

You have undeclared variables. I recommend you use Option Explicit and declare all variables.

Please Login or Register  to view this content.

[vpan]

hi 6StringJazzer , I was trying conditional format initially, but had no idea how to do it, because my range from K2 onwards is dynamic in both row length and column length.

Even though i have the macro working now, If you can help me with getting an equation for this for conditional formatting, i would very much appreciate it!!