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