hello! first post...

I'd like to have a simple pop-up menu in every cell of a column with a specific list of choices...i'd also like that list to be editable so i can make additions and have that cascade throughout the column. The purpose is simple. Just being able to select a status like "In Progress", "Complete" etc. and after that I'll apply conditional formatting to the row based on the selection. How is this done? Not having much luck with Excel's help feature...

thx