Need help writing Macro for shading rows multiple colors

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

Thank you hectop, I think this is exactly what I was looking for. Is there a certain place to go that will list all the different colors available or is that withing our spreadsheet options. Keep in mind I am a newbie when it comes to writing Macros and VBA so I need it in 101 terms LOL

I am just beginning and I am getting an error, can you tel me what I am missing?

End Sub.jpg