Well, I just redid the same thing and now it works. No clue what I did. I started over, highlight my whole table and then set the formatting the same way and now it works.

Gonna be one of those days!!!