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]

Let us assume you put your data in cell C3 and your list of sale types in D3.

 

[glfiedler]

Sorry. Apparently I can't paste a Word document.

 

[jundernoviceuser]

Can you email me a link?

 

[glfiedler]

Tomorrow I will look for a free drop site and then respond here with a link to the Word document.

 

[jundernoviceuser]

Thank you

 

[Fluff]

Sorry. Apparently I can't paste a Word document.

Simply select the text in the word file & then copy paste it into a post as text.

 

[glfiedler]

Thanks Fluff. Unfortunately my document included some screen shots of some Excel dialog boxes. Difinately not the way to do it! I am sorry for the mess that got posted. I tried inserting the images with the image icon but the forum's dialog box asked me for a URL. What is the URL for an image in my computer?

 

[Fluff]

You cannot post images from your computer. You will need to upload them to a share site & then post the URL from that.

 

[glfiedler]

jundernoviceuser,
Follow this link to my Word document with directions along with screen shots of the dialog boxes you will be using. I hope this works for you.
https://drive.google.com/file/d/0B2iL-V9dZ21tc3RhcnRlcl9maWxl/view?usp=sharing