Conditional Formatting applying to totals, how to not include?

Hi Tom, 

I have had this problem as well because Conditional formatting overrides static formatting. To circumnavigate this issue you can add conditional formatting to the Total row and set the criteria to “Not Empty”.  Doing this after the conditional formatting you have already applied will automatically layer this new conditional formatting over the previous one made. You can access the order of conditional formatting by clicking format on top then conditional on the bar on the right. 

I made a topis that mentions this linked below, you can upvote for increased visibility.

Hope this helps,

Seth