I have a list of car dealerships. What I'd like to do is change the color of the cell based on what type of dealership it is. So, for example, if I have the cells:
ABC Ford DEF Chevrolet GHI Honda JKL Hyundai MNO Ford PQR Volvo STU Honda VWX Honda YZZ Mitsubishi
I would like any cells that contain "Ford" to turn red, and cells that contain "Chevrolet" to turn blue, etc.
Is this possible?