I thought so as well, which prompted to find an insane workaround.
It actually will work if you set progress bar’s color to the default blue (the first option in the settings). Then text color of that conditional format rule will be used onto the progress bar. Both the default 8 and the advanced palette of colors will work.