Not clear exactly what you want.
Do you the conditional formatting working?
If so, what else is needed?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...

I have a milestone number calculated for someone to meet, the
number is 9.012, I am displaying it as 9 on the sheet. I have a
conditional format of "if cell A1 is less than cell A2 (9.012) then
RED"; then the second format is "if A1 is equal to or greater than A2
then GREEN". Well if my cell A1 is 9 it will stay red because it is
less than A2, 9.012. I haven't used a formula because I don't know
how. I am in the learning mode, how can I fix this problem.