I will try to explain this a little different and perhaps someone may be able to help and understand better. The counters work always going up in numbers and never having a 0 (zero) so after a 9 it starts over again at 1 123456789. 12345789 they work every other digit "up"

1334

1234

or

1235

1234

So 1234 can be 1334 or 1235

thats one scenario

the other

2234

1234

1244

1234

1234 can be 2234 or 1244

it works like this forever and ever. I'm wanting to be able to build up to perhaps 20 different patterns going up perhaps 10 rows. But what this really means is every time I get a new number they split and double. So, the 1st number becomes 2 like the scenario above. Now you can see I have 4 new numbers to go up 1334 and 1235 and then the other set 2234 and 1244. These two sets will become 8. I have done a few in the attached spreadsheet. The conditional formatting is important. Again all even numbers are Green font with gray shade, Odd are red font with yellow shade

This will definitely help me plus save me ALOT of time and potential of making mistakes that somehow happen

Thank you all !

https://www.dropbox.com/s/gr9n4s9laahri5c/counters%20split%20and%20go%20up.xlsx