Changing cell color based on it's content
===

I have a list of car dealershipships.  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... etc... etc...

Is this possible?