Fill cell colour based on another cells contents.

Maybe this is closer to what you want. Values >0 are highlighted and text values are not highlighted except in the bottom row of each section.

I have no idea if this formatting will be over-written when populated with new data. If "values only" are imported, I would be more confident.