=if(a1="","",if(a1="Blue","Blue","Not Blue"))

the cell with the formula won't be truly blank, but will appear blank.

--
Regards,
Tom Ogilvy



"BlackJackal" wrote in message
ups.com...
Thank you so much for the fast responce but I do have one more
question. Is there a way to manipulate the formula so that if the
intial column is blank the resulting column will also be blank. For
example:

Column A Column B
blue blue
red not blue
<blank <blank