Color-code each letter according to his spreadsheet value
Hi,
I can't solve this problem. I need to create a macro that:
1) Select each character in a text
2) Find that character in a spreadsheet and get the number of his row.
3) Color code (i.e. change the color) the character in the original text according to that number (example, if the character was found between the rows 1-150 color it with blue, if it was in row 151-500 in green, etc.).
I hope the image helps.
Massive thanks,
Zhz
|