the cell D8 does not contain a percentage it is a number (7) and A8 is a number (3). The conditional format on A8 is based on a percentage of D8. In this case 25% that's why I divided by 4 initially. Ideal format is 0-10% A8 is green, 11-24% amber and 25% or more red.