Use Data Validation
--
Gary''s Student - gsnu200774


"JackieJ" wrote:

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"