Change color based on range on another sheet

VolkovIX

New Member
Joined
Aug 17, 2023
Messages
2
Office Version
  1. 2021
Platform
  1. Windows
Hi, A friend in japan asked me if it was possible to create a macro for a project so I'd like to help him but I'm new to excel VBA so I would like to know if there's a way to make what he wants.

The content of the macro is that he wants to have a list of texts in sheet1 that says [Column1/A1:"Wrong"] and [Column2/B1:"Correct"].
For the things in the "Wrong" column, he wants to change the font colors of the strings(not the entire cell) that matches it in Sheet2 to red but ignore the things in the "Correct" column.

Please help check if this is possible.

I've tried other similar ways to change the colors of the string but it won't work as he imagined...
 

Attachments

  • Sheet1.png
    Sheet1.png
    18.2 KB · Views: 15
  • Sheet2.png
    Sheet2.png
    17.8 KB · Views: 13

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
It's also possible to just match the texts in the "Wrong" column without doing anything to the "Correct" column if this isn't possible.
 
Upvote 0

Forum statistics

Threads
1,223,234
Messages
6,170,891
Members
452,366
Latest member
TePunaBloke

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