Applying Color to matching Text in a designation worksheet

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
Hello
How do I produce the following macro:

Find the duplicate texts within the cells of column R in the “Program Logic Models” worksheet that match the exact texts in B5-B94 within the “Impact Matrix” worksheet of the same workbook and apply the same conditional color from the matching record in column FB-F94 of the “Impact Matrix” worksheet to the duplicate texts in column R of the “Program Logic Models” worksheet. The conditional colors in column F where applied to the cell background, however, in column R of the destination worksheet I want it to be applied the duplicate text because the cells in column R will have multiple matches within each cell that matches column B of the originating worksheet. I also need to be able to update the macro results if there is a change in my conditions or text from the originating worksheet.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,224,823
Messages
6,181,184
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top