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