Excel 2007 conditional formating using 3 traffic lights on percent

D

Deb Hodges

I cannot seem to get the conditional formatting to work on values created in
percentages using a formula.

I have copied the values over to the next column and used the number
function and it seems to work ok but each time I change it to percent the
function doesn't give the same traffic light colours!

example below works OK but if I change the Number to Percentage then it
doesn't:

GREEN: >= 75 (Number)
AMBER: >= 70 (Number)
RED: <70 (Number)


It's driving me nuts!!
 
D

David Biddulph

You need to understand what number is being stored. 75% is not the same as
75. 75% is 0.75. You need to compare like with like.
 
B

Bob I

Please consider percentage is a decimal less than 1. 75 would be 7500
percent, 75% is equal to .75
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bug ?? - Excel 2007 Format Wizard formats values incorrectly (icon 1
Conditional Formatting using Traffic Lights 6
change icon color traffic lights in conditional formatting 1
Conditional format - 3 traffic lights 2
Excel 2007 Traffic Light with dates 6
set conditional traffic lights depending on adjacent cell value 2
Excel 2007 - Conditional Formatting Problem with Percentages 3
blank = no formating, <95% Red, >95% Green 13

Top