Conditional formatting with a macro
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
|