Hi,

If I have data in cells such as YDR DYH VNB etc, in separate cells, and I
want to search for a pattern that can span multiple cells how do I do this?
Suppose I want to search the cells for the pattern DRDY (which includes
characters in cells 1 and 2) and color it when its found in the above example?

Matt