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...
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...