Conditional formatting with a macro

[Diana Morrison]

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 isn’t there, I want it to go back to the Manager
worksheet and colour the cell red.

Is this possible?

Thanks,
Diana Morrison

 

[Stefi]

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:

 

[Diana Morrison]

Thanks, I'll give it a go!

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: