How do I restrict what is entered in the next cell?

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

Hi,
I have a list of codes from number 200 to 900. For all codes 400 and under a
clients name needs to be added in the next cell. For all codes over 400 there
does not need to be a client in the next cell. How can make it so when
someone enters the code 400 or under they have to enter a clients name in the
next cell?

Tx
 
If the codes are entered in column A then in C1 enter:

=IF(A1="","",IF(A1>400,"",IF(B1<>"","","enter a name in column B")))
and copy down

This will expose a reminder that the client name has not been entered in
column B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
sumif multiple criteria, some same cell 6
Restricting Cell entry to certain letters 7
Excel Message box called if 1 of 3 options is entered. 4
OFFSET equation not working 3
sumproduct, multiple if, some same cell, determine number of rows 4
Data validation - restricting data 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top