Thank you! I had to modify a couple of things, but the formatting is now working perfectly. My biggest mistake was in my named ranges. Since I wanted to allow for future growth of the ranges, I just selected a random range somewhere around cell 5000, but all three ranges were different.

After reading through the link in your previous post I found out that the ranges have to be the same size when used in a calculation. When I changed them all to 5000, the formatting materialized!

Thanks again!