Conditional formatting with decimals

[seanbtrini]

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.

 

[Bernard Liengme]

Not clear exactly what you want.
Do you the conditional formatting working?
If so, what else is needed?
best wishes

 

[Guest]

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.

 

[seanbtrini]

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





- Show quoted text -

Thank you! That did it.

Sean