.
Ok.

I thought the red colored cells were something you were experimenting with ... that is why I deleted the red color. Prior to doing so, when running the macro, the yellow
did not "bleed through" or change the red color. So ... if you simply place the red color back in the cells it should run as desired. If not, come back ...