Autofill Help

Hi All,

I am in search of a code and do not have a code at this time to go off of. I'm looking for a VBA code to Autofill my cells in a specific order by a cells specific color. The colors are blue,grey, and no fill. The numbering sequence changes depending on these color. For example:

1. Blue cell
1.1 Grey cell
1.1.1 no fill cell
1.1.2 no fill cell
1.1.3 no fill cell
1.2 Grey cell
1.2.1 no fill cell
1.2.2 no fill cell
1.2.3 no fill cell
2. Blue cell
2.1 Grey cell
2.1.1 no fill cell

I have included a screenshot to help better explain.

Originally Posted by 6StringJazzer

Are you trying to fill the color based on the numbers, or create the numbers based on the colors? That is, what is the "before" picture?

Create the numbers based on the colors