Choosing between conditional format, VBA, or Power Query

My company has a google sheet where they have a series of “index cards” that are used to fill in the blanks. The top and bottom lines are always the same. But the middle can be as few as six rows or as many as 21 (that I have seen thus far) but could possibly go higher.

What I want to do is copy all the cards and paste into excel as values.

Then I want to change the fill color of column C based on a value in column B and I want that color to fill down to the cutoff line which is also based on a specific value in column B. Theoretically the empty cards will all have a stripe down the middle that can be sorted and deleted.

The live cards change daily as jobs are completed and they are deleted or someone uses an empty card to fill in new info to create an active card.

I can’t think of a conditional format formula to do this. I’m pretty sure I could clean it out in power query. I could also take a stab at it with VBA.

Which would you recommend, and if it is conditional formatting what formula would work do you thinK?

Using desktop Excel 365