I am trying to change the font color in one cell if another cell has a certain value. The values range from 6 to 12 and each value requires a different color. I have 27 rows to do this for so I was wondering if there was a better way to go about this than creating 189 conditional statements. I am using Excel 2007 on a PC.