I often demonstrate how to conditionally format based on looking for particular text in a cell, but what if two (or more) words have to be in the text string. In the example below, I want to show cars that are both DIESEL and ESTATE.
Selecting the column, I clicked the Home tab, then in the Styles groups, the Conditional Formatting tab dropdown and click New Rule. Select Use a formula to determine which cells to format.
The relevant column was column C, so in the Format values where this formula is true box, type
Click Format and format to your choice, then click OK three times. Your dataset should be formatted as required.