79157622

Date: 2024-11-05 03:44:09
Score: 1.5
Natty:
Report link

Use conditional formatting to color-code the drop-down list:

Select the cells with the drop-down list

Click Home > Conditional Formatting > New Rule

Select Format only cells that contain

Choose the condition for color

Select the color formatting

Click Format

Activate the Fill tab

Select the highlight color

Click OK, then click OK again

Reasons:
  • No code block (0.5):
  • Low reputation (1):
Posted by: abhay sharma