You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list.
Here is how I did it.
Create a drop down list
- Select cell D3
- Go to tab "Data"
- Click "Data Validation" button
- Go to tab "Settings"
- Select List
- Type: No formatting, %, Time, Above Average, Below Average
- Click Ok!
Here are the formulas and formatting:
The formula checks if the value in cell D3 is %. If true the following formatting is applied:
The formula checks if the value in cell D3 is Time. If true the following formatting is applied:
In this formula, cell D3 is "Above Average" AND checks if each value is above the average of the table values. If TRUE the cell is highlighted.