View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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