Data Entry

[JackieJ]

I am creating a spreadsheet to gather information from managers. I want to
enable the managers to input data in a cell only if the adjacent cell
contains the word "eligible"

 

[Gary''s Student]

Use Data Validation