I'm trying to do a conditional with some cells that are formatted like
so.

Range("B" & i & ":S" & i).NumberFormat = "0"

(so that they show up as whole numbers)

and I'm running the If like so

If Range("R" & i).Value < "0.5" Then
color the row

the problem is that its catching the 0.5's and stuff but for some
reason its not catching the 0.0833333 which in my math education is
less than 0.5 but for some reason its not registering as less than 0.5.
Does anyone know why?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=469586