I have a sub now that searches for specific text in the A column, and stops when it finds that text. Once it find that text, I need it to do the following:
1. From the active cell, search upwards in the same column until reaching a cell with value Interior.Color = RGB(255, 0, 0).
2. Once that cell is reached, stop, and capture the cells row number as a variable.
Bookmarks