I have a worksheet (Summary) that pulls information from another worksheet
(Manager).

I want to run a macro from the Manager worksheet, that first looks at every
number in column A, and tries to find it in column A of the Summary
worksheet. If the number isnt there, I want it to go back to the Manager
worksheet and colour the cell red.

Is this possible?

Thanks,
Diana Morrison

You don't need a macro for it!

Create a named range of column A of the Summary worksheet, say SummaryAcol,
and add conditional formatting to column A of Manager worksheet with this
formula:

=AND(NOT(ISBLANK(A1)),ISERROR(MATCH(A1,SummaryAcol ,0)))

Regards,
Stefi

€žDiana Morrison€� ezt Ã*rta:

I have a worksheet (Summary) that pulls information from another worksheet
(Manager).

I want to run a macro from the Manager worksheet, that first looks at every
number in column A, and tries to find it in column A of the Summary
worksheet. If the number isnt there, I want it to go back to the Manager
worksheet and colour the cell red.

Is this possible?

Thanks,
Diana Morrison

Thanks, I'll give it a go!

"Stefi" wrote:

You don't need a macro for it!

Create a named range of column A of the Summary worksheet, say SummaryAcol,
and add conditional formatting to column A of Manager worksheet with this
formula:

=AND(NOT(ISBLANK(A1)),ISERROR(MATCH(A1,SummaryAcol ,0)))

Regards,
Stefi

€žDiana Morrison€� ezt Ã*rta:

I have a worksheet (Summary) that pulls information from another worksheet
(Manager).

I want to run a macro from the Manager worksheet, that first looks at every
number in column A, and tries to find it in column A of the Summary
worksheet. If the number isnt there, I want it to go back to the Manager
worksheet and colour the cell red.

Is this possible?

Thanks,
Diana Morrison