how to search for text within a range and return "text" value

[edezagon]

[TABLE="class: grid, width: 20"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]RED;BLUE;YELLOW;GREEN[/TD]
[TD]=ISNUMBER(SEARCH($C$1:$C$3,A1)) ?????[/TD]
[TD]PURPLE[/TD]
[TD]BLUE[/TD]
[/TR]
[TR]
[TD]RED;PURPLE;YELLOW;BLUE[/TD]
[TD]BOTH[/TD]
[TD]RED[/TD]
[TD]GREEN[/TD]
[/TR]
[TR]
[TD]PURPLE;GREEN;RED;[/TD]
[TD]BOTH[/TD]
[TD]YELLOW[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]YELLOW;BLUE;PURPLE;[/TD]
[TD]BOTH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PURPLE;RED;YELLOW[/TD]
[TD]COLOR1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RED;YELLOW;[/TD]
[TD]COLOR1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BLUE;[/TD]
[TD]COLOR2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BLUE;GREEN;[/TD]
[TD]COLOR2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RED;GREEN;[/TD]
[TD]BOTH[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]PURPLE;[/TD]
[TD]COLOR1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I have above range.

I want to show all those that have ONLY values from COLUMN D or ONLY COLUMN C or BOTH (call them COLOR1 and COLOR2 and BOTH)
Can I do this on one formula or do I need 2 columns of answers? Either way is OK for me.

I've looked in the forum and found a few answers, but not range within a range of partial text.

Thanks,
Elisabeth in Brussels.

 

[edezagon]

Sorry... Column B is where I want the formula/answer... Thanks!