Try this instead:

=ISNUMBER(MATCH(A1,COLOR,0))

Hope this helps.

Pete

On Feb 24, 12:19*am, apache007
wrote:
I have Worksheet A containing a list of data:
Red, Yellow, Orange, Purple which is defined in NAME MANAGER as COLOR

Worksheet B on CELL A1, is user input data

A2 has the following formula
=OR(A1=COLOR)

User input : *Red * *= *FALSE
* * * * * * * * * Yellow *= FALSE
* * * * * * * * * *Orange = True
* * * * * * * * * Purple * = FALSE

The OR formula should produce TRUE value on the cell for all input that is
true. However, it is not the case. Where is the formula wrong?