Steve's answer worked. but now I want this function to work for the entire
column. I can manually change the The row number each time but there has to
be an easier way.

"John Bundy" wrote:

See if this does what you are asking, paste in M1 or adapt for your first cell.
=IF(C1="Red",1,IF(C2="black",1,""))
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"cyrock1" wrote:

I'm trying to figure out a function for a column. I want column M to look at
column C and IF the word in column C is "black" or "red" i want column M to
show a value of "1"