Create your drop-down list in any cell using Data Validation with fields. Highlight the drop-down cell. Select Conditional Formatting. Select Highlight cell rules, more rules. Select Format only cells that contain. Change the value in the format only cells with: to Specific Text.