View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stu Stu is offline
external usenet poster
 
Posts: 29
Default Conditional Formatting color doesn't show up: 90%

Yes its from a formula but its not set to round-up. Its just set to zero
decimal places


"Eduardo" wrote:

Hi,
does the 0.9 come from a formula, if yes check it I think the result of the
formula is 0.89999 or something similar which is not 0.9

if this helps please click yes thanks

"Stu" wrote:

I have a cell formatted to show a number as percentage and the conditional
formatting rule says Between 0.9 and 1 will be green. 0.9 is showing up no
color
but any value from .91 - 1 shows up green. Should "between" .9 and 1 include
.9?
Is this a known bug?