Loop until activcell contains...

[AlexCoyne]

I have searched far and wide but maybe I'm just trying to use the wrong type of loop. I want my loop to apply conditional formatting to every line of an invoice spreadsheet until it gets to a line for the customer signature, but the text in this line is not the same in every spreadsheet, so I just want it to stop when it gets to a line containing the text "customer". Can anyone help me out?

Please Login or Register  to view this content.

Thanks in advance.

[wallyeye]

You can try this out:

Please Login or Register  to view this content.

It is a bit longer code, but does less processing. Change the Set rngStart line to point to the starting cell of the data on your worksheet. It first finds "Customer" in the given column, then assigns a range object to the cells from rngStart to the cell right above "Customer". It deletes any existing conditional formatting, then adds new conditional formatting as your code does.

[AlexCoyne]

That looks awesome! It doesn't seem to be working though. My data starts is D19 and then the text to make it stop is also in that column; would that need to be in there?
Thanks,
Alex

[wallyeye]

Change the Set rngStart line to point to D19 instead of A2...