Thanks very much, and yes I was talking about text. Thanks again for your help.
Kevin

"RagDyer" wrote:

Try this:

=IF(OR(A1={"RED","BLUE","GREEN","BLACK","ORANGE"}) ,1,0)

I'm sure you're talking Text here, and *not* the actual colors of the cell.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"kevin" wrote in message
...
Once again thanks for your help folks. Could someone show me how to write
the
following if statement. =IF(A1=RED OR BLUE OR GREEN OR BLACK OR ORANGE,1,0)
I know these would all need to be in "" but I am not sure what separator to
use.
--
Thanks Kevin