Excel data validation

[jundernoviceuser]

I'm. Novice user. I am trying to use Excel as a sales pipeline. I want to be able to put data into a cell, then have a drip down menu ( pending; sales ; on hold; sold etc..
Each of these will reflect a different cell fill color.

 

[glfiedler]

here is the correct link to the Google Doc. Google share does not like Microsoft products. Can't the world get along?
https://docs.google.com/document/d/1xM_Umn2mHbGG_-F1BlKBOjHbMIVFvkzgUW0S-lNAdbA/edit?usp=sharing

 

[jundernoviceuser]

Thanks