Excel 2007 conditional formating using 3 traffic lights on percent
 

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!!

--
Deb

Excel 2007 conditional formating using 3 traffic lights on percent
 

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.
--
David Biddulph

"Deb Hodges" .(donotspam) wrote in message
...
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!!

--
Deb

Excel 2007 conditional formating using 3 traffic lights on percent
 

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

Deb Hodges wrote:

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!!