Thanks for thw quick reply, guys. I went with benishiryo's solution using conditional formatting. It works best for me because often the data is copied and pasted into these cells, and also because the format of the sheet is pretty rigid, so I didn't want to add or hide any additional columns.

Works perfectly. Thanks for the help!

This thrread is solved!