I'm not using conditional formatting because I would like the font size changed and as far as I know that can't be accomplished in conditional formatting.

I've input your solution here and it worked, but when I change some of the font colors, i.e. from 1 to 3, I can't get it to run again. Will this macro be something that can continuously run and update my sheet as often as cell values change?

Please forgive the naivete.

Thanks