Find and highlight cells within different ranges.

[14spar15]

Hello, I would like to find the value in cell C2 in every case within the range of the value in cell A2 and value of cell B2. In the example here I would like cells B4, B6, and B9 to be highlighted or clearly pointed out somehow. When I run my Macro3 there are a few problems.



1. The results are shown in a message box. I just want the results highlighted.

2. I’m only finding the first found result. I need to see all of them. I was going to try and figure out a loop but the range can sometimes be different.

3. In this example, B4 is not found because it does not start with “gre”.

Thanks for any help.