I want to set up the conditional formatting on a cell in such a way that if
the number entered into the cell does not exist in a database (another
workbook,) that cell will change colors. The trouble I am having is in
referencing the database workbook while it is not open. There must be a
..find function I can use to look in an xls file on the local drive to
accomplish this? If anyone could give me suggestions, I would appreciate it
:)

-Mike