|
|
#1
02-08-2018, 05:47 PM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking for code to start me with a Yes/No letter | Shales | Word VBA | 1 | 09-22-2017 03:14 PM |
| How to replace a letter to random letter with different color? | cikanoz87 | Word | 7 | 06-18-2015 09:43 PM |
 every letter different color
|
skan | Word VBA | 8 | 03-28-2013 04:16 AM |
| vba Code to Print Spreadsheet to PDF | OTPM | Excel Programming | 3 | 05-25-2011 08:22 AM |
| Color code filenames in explorer | terence_laoshi | Office | 0 | 01-18-2011 11:01 PM |
Windows 8 
Office 2013
Threaded Mode