Frank Freese
asked on
Drop down list
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
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
Use Data Validation as explained here
ASKER
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
ASKER
I was wondering about using Conditional Formatting with a special rule but I can't seem to get there, as an alternative
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subodh,
That's it! I couldn't get my mind around my objective was my problem.
Roy, thanks for your input
That's it! I couldn't get my mind around my objective was my problem.
Roy, thanks for your input
You're welcome Frank! Glad it worked as desired.