Alright this is what I need to do. I need to be able to automatically
assign information into a column based on the data entered into another
column in this manner. If in column A the information entered is
anything but "blue" I want the text "not blue" entered into column B.
If blue in entered into column A then column B should read "blue". For
Example:

Column A Column B
red not blue
green not blue
purple not blue
blue blue

I can't seem to figure this one out thanks in advance.