"simpsonehh" wrote:
thank you for the response. That formula looks like it is working great.
Welcome. Please press the "Yes" button from where you read this.

How would I get it to clear the cell from the source sheet if a match is found?
Rather than remove the entry from the source list. I want to change the
font red or some other color. Is that possible?
Formulas cannot do the above. Try a new post in .programming.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---