Conditional Formatting Based On %

**alexmallaburn** · 10-28-2008, 12:03 PM

I am wanting to change the colour of a cell e.g F9 based on the percentage of cell G9

(The state column)

I want it red if = 0 %
orange if between but not equal to 0 & 100
green if = 100%

I've tried cf but the green displays as orange ? I'm rather confused

I'm using 2007 in compatibility mode because my schoolCo has 2003

**DonkeyOte** · 10-28-2008, 12:18 PM

Remember that % are decimals so you want =0, greater than 0 and less than 1 and then = 1.

**pauldaddyadams** · 10-28-2008, 12:24 PM

You would need conditional formating:

=$G$9=0%
=OR(G9>1%,G9<99%)
=$G$9=100%

**shg** · 10-28-2008, 12:24 PM

Condition 1: Cell value Is, equal to, 0 (format red)
Condition 2: Cell value Is, equal to, 1 (format green)
Condition 3: Cell value Is, between, 0 and 1 (format orange)

Paul, your solution doesn't color, for example, 0.5% or 99.5%