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 |
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 |
Conditional formatting with a macro
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 |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com