Hi, I have the following formula that i use, is there a way to have the
numbers in a worksheet as they will change ie.. numbers will be added
and removed.

=AND(OR(AND(B3=121,B3<=125),AND(B3=149,B3<=156), AND(B3=320,B3<=363),AND(B3=700,B3<=799),AND(B3= 800,B3<=991)),COUNTIF($B$3:$E$46,B3)<2)

Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile: http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=536648