You can automatically have cells turn certain colors based on the text within those cells. This is easily done using one of the many types of conditional formatting.