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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

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