<div>
Use Data Validation as explained <a href="https://www.contextures.com/xlDataVal01.html" rel="ugc">here</a>
</div>


<div>
Remember there are 2 options: Recruiter or Hiring Manager. I did not see how data validation would work. For example, if it was a Recruiter I only want to see Recruiter not Recruiter or Manager
</div>


<div>
I was wondering about using Conditional Formatting with a special rule but I can't seem to get there, as an alternative
</div>


DataValidationList.xlsx

DataValidationList.jpg

Frank Freese

<div>
Subodh,<br />
That's it! I couldn't get my mind around my objective was my problem.<br />
Roy, thanks for your input
</div>


<div>
You're welcome Frank! Glad it worked as desired.
</div>


<div>
<div class="content wysiwyg-content">
Folks,<br />
Another senior moment for me. Using Excel 2016 I have a column labeled <b>Recruiter or Hiring Manager</b>. When I get to that column I would like to select either Recruiter or Hiring Manager and place my selected item in that cell so I know if I'm talking to a recruiter or hiring manager
</div>
</div>


Folks,
Another senior moment for me. Using Excel 2016 I have a column labeled Recruiter or Hiring Manager. When I get to that column I would like to select either Recruiter or Hiring Manager and place my selected item in that cell so I know if I'm talking to a recruiter or hiring manager

Drop down list

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.