Find cell content and format cell accordingly

Hi,

I have some useful code to find specific content in a column and format it. My problem at this point is, how do I tell Excel to look for any content within the given range and then format it as indicated? Most cells within the range will be empty, and just a few will have content (either numbers or text). Those are the ones I need formatted. Additionally, I need to introduce the offset property to format the corresponding cell in column A the same as the one in column L (That is, same row, but cell in column A). What do I have to adjust within this code? Is there any better approach to this?

Thanks for any help!

(I'm using a "?" sign in the sample below to indicate the piece of code I'm looking for)

Please Login or Register  to view this content.

Hi Jeff!,

Thank you so much for your help. Adjusting the line of code where the value is set, made the trick. However, the second part of your code, the one marked in red, didn't do anything. I came up with a solution that worked, this is the code:

Please Login or Register  to view this content.

Since this worked, I'm marking this post as solved.

Thank you again!