restricting data when other cell is empty.
 

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


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

restricting data when other cell is empty.
 

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



--
Regards
Frank Kabel
Frankfurt, Germany


ZOHAR BATTERYWALA wrote:
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


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