Need to input text before inputting a number

[Brandy]

Thank you for your help! It worked a treat


Hello,

I would like to ensure the managers input the employee's performance rating (Outstanding, Successful, etc.) in column A before a bonus amount can be inputted in column B. How can I put that restriction on the cells in column B?

I have done something similar by using the data validation and ISNUMBER to ensure a numerical value had been inputted before the bonus amount could be.

Thank you for your help.

Brandy

[NBVC]

You can create a list of acceptable (expected) inputs for column A in a table somewhere, then use data validation in column B with Custom selection and formula:

=MATCH(A1,table,0) where table is the table range you created (single column).

or you can use data validation List in column A to force them to pick from list and then column B validation would be Custom... A1<>""

[Marcol]

Try this workbook.

Data Validation > Custom
Formula:=

Please Login or Register  to view this content.

Uncheck the ignore blanks checkbox

Column C is just to prove the formula and can be deleted.

Hope this helps.