View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Elardus Elardus is offline
external usenet poster
 
Posts: 15
Default Conditional formatting problem - MS' definition of "between"

In my mind , the notion "between" should mean that the limits used to define
"between" should not be part of the resulting answer. Seemingly not so with
Excel 2007 conditional formatting though - When I add a rule to highlight
values between say 0 and 3, I was hoping not to see the values 0 and 3
highlighted....

How do I solve this without reverting to unsatisfactory "between" limits of
something like 0.00001 and 2.99999 .....?