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