Looking to quickly color code data without having to push a button? Conditional formatting is your answer.

This feature is great for splitting student first and last names contained in one column.