MS Excel - Add drop down list and add conditional coloring or formatting

Detailed Steps:

Select the cells of the field. Here, Status. >> click on data tab

Data validation

Validation criteria >> allow as List

Source: Provide the list values

See the list is ready.

Now we will add conditional coloring.

Select the cells >> conditional formatting 

Select New Rule

Select Format only cells that contain >> equal to >> specify one value . " Not started". >> Format.

Select a color.

Ok

See its ready for Not started. Similarly , we can add for other values and colors.