You could use the AND and OR functions.

=OR(B1=5,B1=10,B1=15)

=OR(AND(B1=5,B1<=10),B1=15)


"darkbearpooh1" wrote:


Ok, Now how do i make it accept a range like you said conditional format
if A1=5 but I need it to accept several different numbers and still
change color?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=503516