Change dropdown colors in Google Sheets
Build a stable dropdown-color key by entering exactly "Red" in B2, "Amber" in B3, and "Green" in B4. Then make B2 bold. Keep the priority names unchanged.
Verified by PhilisAbout 60 secondsBuild a stable dropdown-color key by entering exactly "Red" in B2, "Amber" in B3, and "Green" in B4. Then make B2 bold. Keep the priority names unchanged.
Step-by-step
Select the targetBuild a stable dropdown-color key by entering exactly "Red" in B2, "Amber" in B3, and "Green" in B4.
Complete the next actionThen make B2 bold.
Apply the changeKeep the priority names unchanged.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
The priority key maps High to Red, Medium to Amber, and Low to Green, with the High color label bold.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select B2 and repeat the final action. The priority key maps High to Red, Medium to Amber, and Low to Green, with the High color label bold.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Priority | Color label |
| High | |
| Medium | |
| Low |
Video transcript
- Open the prepared Dropdown colors spreadsheet.
- Select the target. Build a stable dropdown-color key by entering exactly "Red" in B2, "Amber" in B3, and "Green" in B4.
- Complete the next action. Then make B2 bold.
- Apply the change. Keep the priority names unchanged.
- The priority key maps High to Red, Medium to Amber, and Low to Green, with the High color label bold.