Friday, April 7, 2023

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.


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

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...