There is formatting in the totals column that appears to interfere with the conditional formatting when the table is refreshed. I have tried several things to try and override this but have been unsuccessful.