I am trying to help a friend with his sheets. I have several different strings of numbers that range from 2 numbers like 68 to 7 numbers like 4444864 that I need to shade a different color on several sheets in several books, Can anyone start a Macro for me and explain how I can shade these. I believe if someone gets me started I can take off with it once I understand the concept.
How my sheets work is I add new numbers into 4 columns (columns STUV for example) once new numbers are added to STUV the numbers in column "R" for example will change therefore a new string needs to get shaded a different color.
How do I write a Macro for say the 642 in column "R" which is bright yellow shade with Bold Royal Blue font and a royal bold border. The reason the number 2 changed to yellow font and blue shade is because it is part of another string that is opposite 246 which is royal blue shade and bright yellow font with a bright yellow border. For all intentional purposes I can just color code the 64 in one and the 24 in the other. The other shade for example would be the 6-10-2 which is black shade with bold red font and a red border. you can glance across this picture or spreadsheet and see the different shades I use. I want to be able to write a Macro for all of them. Keep in mind I have approx 18 different columns i will want to shade so I will need to know how to include several columns to do the same rules (example B, R, AH, AX.....)
VBA for shading.jpg
Shading No Formulas.xlsxVBA for shading.jpg
Thanks for your help
Bookmarks