Select the range of cells you want to format then select CONDITIONAL
FORMAT - then select BETWEEN and enter the values. Seemed to work ok
for me. Make sure your program puts "" around the value.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496217