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