restricting data when other cell is empty.

[ZOHAR BATTERYWALA]

Respected Sir,
IN A CELL(I3) NO VALUE SHOULD BE ACCEPTED IF OTHER CELL(D4) IS
EMPTY/CONTAINS VALUE THAT IS NOT IN A PARTICULAR LIST(LIST OF
SUPPLIERS).
Zohar
[email protected]

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Frank Kabel]

Hi
try the following:
- Assumptions: A1:A10 stores your list of supplieres
- select cell I3
- goto 'Data - Validation - Custom'
enter the formula
=COUNTIF($A$1:$A$10,D4)>0
- uncheck 'ignore blank cells' in this dialog