Excel Hack 50: Highlight instances of a string within a range
Below is a demonstration of a VBA macro that helps to select the cells in a range containing the string indicated in a reference cell. The set up is in 4 basic steps: Identify the range you are searching for the string instance in, and name it (optional). In the example above, this range is