Conditional formatting for categorical (text) data

Conditional formatting for categorical (text) data with an auto-assignment of colors would ease visual inspection of data. See the enclosed screenshot borrowed from MacWizard.