I missed a comma inbetween;try
=AND(A10,A1<3)

If you want to include 0 and 3; then
=AND(A1<"",A1=0,A1<=3)

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

--Select the range of cells. Assume this range is A1:A7

--Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format

--Enter this formula in the box below:
=AND(A10A1<3)
Please note that the cell reference A1 is the active cell in the selection.
Active cell willhave the white background even after selection

--Click the Format button. Select the desired style(s) and click OK
If this post helps click Yes
---------------
Jacob Skaria


"Elardus" wrote:

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 .....?