Find and highlight cells within different ranges.
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.
|