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 - Delete file from OCI Object storage bucket using rest connection

Business requirement: In Oracle Integration Cloud (OIC), there is a need to automate the deletion of files from an OCI Object Storage bucket...