Multiple condition filter

[Lumjing]

From the below data set I want to filter out if Numbers = 21143 and colors = Red, Blue,Green, Yellow, Orange and Status = closed or blank. I have tried using filter and join tool but that does not help as in join the status blank cannot be done. Can someone please help

Numbers	Color	Status
21134	Red	Closed
21134	Blue
21134	Green
21134	Yellow	Closed
21134	Orange	Closed
3654	Black	Open
3654	Grey	Open
3654	Brown	Open
3654	Color	Open
5432	Red
5432	Blue
5432	Green	Open
5432	Yellow	Open
5432	Orange	Open
5432	Black	Open
5432	Grey	Open
5432	Brown	Open

[PhilipMannering]

This in a Filter Tool should work,

[Numbers] = 21134 and
[Color] IN('red','blue','green','yellow','orange') and
(isempty([Status]) or [Status]='closed')

See attached.