I got it now

Thanks


Tom Ogilvy wrote:
use countif in a conditional format formula. You will have to define
the
range in another workbook using a defined name. The other workbook
will
have to be opened. If that is not possible, then you will have to
link to
that range in the other workbook and reproduce the values in the
current
workbook.

--
Regards,
Tom Ogilvy


"Andrew T Smith" wrote in message
...
Hey,

I'm looking to create a macro that compares one cell to a range of
cells in another work book. If the cell matches a cell in the range
if
highlights the original cell. Is this possible and if so how.

Andrew