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.

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.

Instead of putting in A2 put in

=Text(A2,"0")*1

in both cases. Put the equal sign in the textbox as part of the formula and
leave the conditions as you currently have them selected in the dropdown.

--
Regards,
Tom Ogilvy


" wrote:


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.

On Jul 2, 11:32 am, Tom Ogilvy
wrote:
Instead of putting in A2 put in

=Text(A2,"0")*1

in both cases. Put the equal sign in the textbox as part of the formula and
leave the conditions as you currently have them selected in the dropdown.

--
Regards,
Tom Ogilvy



" wrote:

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.- Hide quoted text -

- Show quoted text -

Thank you! That did it.

Sean