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