Hi, I have searched but not able to find what I'm after.

I am trying to return 3 different colours for percentage ranges in excel.

I can get two colours to work - but not the 3rd.

This is what I'm trying:

IF$F$76>=95% (Green)

IF$F$76>=85% (Yellow)

IF$F$76<85% (Red)

I can get Red and Green to work, or Red and Yellow, but not all 3.

Anyone know what I'm doing wrong?

I am trying to return 3 different colours for percentage ranges in excel.

I can get two colours to work - but not the 3rd.

This is what I'm trying:

IF$F$76>=95% (Green)

IF$F$76>=85% (Yellow)

IF$F$76<85% (Red)

I can get Red and Green to work, or Red and Yellow, but not all 3.

Anyone know what I'm doing wrong?

Last edited: