Macro to mark a cell -> move to next and reset on specific color for each row separately

[NextYollow]

Hello everyone, I have nearly 0 experience with macros unfortunately I could really use one of your magical knowledge. Could anyone please help me out with "one button does it all" type of macro ? I am totally lost....

What is required:
The "x" marker would move one cell to the right for each row separately and reset to the original "day 1" cell once reaching the "purple" color ( reset after click while placed on purple )

Where it would be used: As per attachement

We can also discuss some form of appreciaction...

 

[vletm]

NextYollow​

I gotta guess some of Your requires.
Usage:
Take care that You've those 'x' in B-column
Press [ Do It ]

 

[NextYollow]

Oh man, almost there, now I really kinda consider this a magic especially this fast :D
Thank you so much for taking care of me.

Can it work in a way of "one click = one cell move" ? I mean so I does stop after single move and I have to press it again for it to move again one cell ?
Also for the X could it reset back to starting position when It reaches the end for each Value line independently?

So that it works like
First press: Move all X one cell to the right
Second press: Move all X once cell to the right
Eighteen press ( example for Value 1 ): Reset X to 1 and start over. ( all the others that DID not hit Purple would move on to the right by one cell.

 

[vletm]

Something like this?
with bonus: Reset & ALL

 

[NextYollow]

WOW you are a true master with excel. Now I understand the title "Excel Ninja" This is exactly what I wanted and would never be able to pull off.
Thank you again very much mister. Hopefully you have recieved my small token of appreciacion aswell yesterday.

I was sure in advance its going to be a piece of cake for you
*SOLVED

 

[vletm]

I've still wondered about those white cells ... hmm?
Should those try to take care like this files List2-sheet?
There are some other minor details ... I've tested something.

 

[NextYollow]

Ok now we are definitely in a area of "I had no idea what can macros do" :D
This is even better as those "white" start cells have to be there in a form 3days ofset. I just didnt know that start of each line can be in different cullom.
Thank you for the lifecycle counter addition with colours "highlight" as that will help a lot of keeping track of how many cycles it went through without me having to count and remember separately.
This is a lot more than I was even hoping for.
Have seen couple of macros from guys around ( non of them worked for me ) but now looking at the code of yours I understand why :D
Genius !