View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Piscator Piscator is offline
external usenet poster
 
Posts: 10
Default dynamic range and data validation

Highlight the cells.
Select Data, Validation.
The "Error Alert" tab is where you can insist an entry is only allowed
from the list as an Error, Warning or for Information only.