Conditional Formatting Based On %
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
Remember that % are decimals so you want =0, greater than 0 and less than 1 and then = 1.
You would need conditional formating:
=$G$9=0%
=OR(G9>1%,G9<99%)
=$G$9=100%
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%
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
I love these repetitive threads... maybe I should post another solution too ;-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks