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

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

I'm sort of confused on this. I get where the conditional formating is
but i don't understand the countif thing. i almost need a 'is one of'
option. Help?

Andrew

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