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.


Ok


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




No comments:

Post a Comment

Featured Post

OIC - Moving a File using FTP connection now throws IO operation failed error

Error usecase: Moving a File using FTP connection now throws IO operation failed error. The integration has been working for weeks, with a f...