View Single Post
  #1   Report Post  
JavyD
 
Posts: n/a
Default Validation Based on a Date

Is this possible. Can I place a validation on an entire column to allow or
prevent data entry of whole numbers if I set the validation to accept a
change only like so.

for January - column E, validation would be to stop entry of info if =now()
is greater than 01/01/2005? No macros please , because it's over 200
workbooks that are emailed out and these guys would disable the macros.