Conditional formatting error
 

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

Conditional formatting error
 

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

wrote in message
oups.com...
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

Conditional formatting error
 

On Jun 21, 11:50 am, "Vasant Nanavati" <vasantn AT aol DOT com wrote:
Are these calculated values? Perhaps there are decimal places that are not
showing (i.e., the numbers could be 49.01 and 48.99.
__________________________________________________ ___________________

wrote in message

oups.com...



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

- Show quoted text -

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

Thank you!