A shortcut for copying an X into a Column B based on data in Column A
Put a formula into column B (e.g. in cell B1)

=if(a1="red";"X";"")


You can also stack the ifs for different values

=if(a1="red";"X";if(a1="blue";"Y";"")