View Single Post
  #1   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%

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?