Conditional formatting error

[seanbtrini]

I have cells set up with conditional formatting;

If cell value(R14) is Less than (R15) then format (R14) red
If cell value(R14) is Greater than or equal to (R15) then format
(R14) green

My value in "R14 is 49 and "R15" is 49 but "R14" is coming up red when
it should be green.

Thank you in advance,
Sean

 

[Vasant Nanavati]

Are these calculated values? Perhaps there are decimal places that are not
showing (i.e., the numbers could be 49.01 and 48.99.
_____________________________________________________________________

 

[seanbtrini]

Are these calculated values? Perhaps there are decimal places that are not
showing (i.e., the numbers could be 49.01 and 48.99.
_____________________________________________________________________









- Show quoted text -

You were right, my calculated cell "R15" had a value of 49.36.

Thank you!