BTW, the cell my have a number or text in it but not formulas

"Dan" wrote:

How can I compare a column from worksheet 1 to a column in worksheet 2 of the
same work book?