.
Help me understand.

How do the red colored cells become red ? Did I miss that in the code you provided ?

And in the Columns Q:U you only want the non-colored cells to be colored yellow ? Do they need to stay yellow or what ?