Try something like this:

Define this Named Range:
Name: LU_TrafficLights
Refers to: ={"Green","Yellow","Red"}

Now, for a value in A1
B1: =IF(OR(A1=LU_TrafficLights),1,0)

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Barb Reinhardt" wrote:

My formula currently looks like this

=if(or(A=Green,A=Yellow,A=Red),1,0)

unfortunately A is a fairly long formula. Is there a more elegant way to do
this?

Thanks,
Barb Reinhardt