CF - conditional formatting
Filter - filter each column by NoColor starting from far left
you just retyped in many words all what I show with one table
what is your office version?
could you write single, one step, code vba?

not like this where it is not clear what to do
mvba.png