I appreciate the help on this. This is the formula that I am using: =IF([Status]4=At Risk, "Red", IF([Status]4=Not Started, "Yellow", IF([Status]4= Complete,”Green”, IF([Status]4= In Progress "Blue",””))))