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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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


"(E-Mail Removed)" 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 <TomOgi...@discussions.microsoft.com>
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
>
>
>
> "seanbtr...@gmail.com" 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