If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel 2007 formula help

squelly · 2010-06-28 19:52:30

I am trying to dis-able cell data entry once a certain date has elapsed. I know how to add the current date to a worksheet. my formula would refer to this and if someone trys to enter values after a certain date set by me the cell will become in active and an error message will appear. any help? thx

28-06-2010 7:52pm

#1

squelly

Registered Users, Registered Users 2 Posts: 73 ✭✭

Join Date: September 2006

Posts: 60

I am trying to dis-able cell data entry once a certain date has elapsed.

I know how to add the current date to a worksheet. my formula would refer to this and if someone trys to enter values after a certain date set by me the cell will become in active and an error message will appear.

any help? thx

0

Comments

#2 29-06-2010 8:36am

rockal

Registered Users, Registered Users 2 Posts: 757 ✭✭✭

Join Date: March 2006

Posts: 751

Select the cell, then from the top ribbon go to Data>Data Validation>Settings and select Dates.

0
#3 29-06-2010 2:05pm

squelly

Registered Users, Registered Users 2 Posts: 73 ✭✭

Join Date: September 2006

Posts: 60

Rockal,

that would work if the data i wish to enter is a date, however the data to be entered are whole numbers.

basically i have ten cells requiring data entry ( i.e number) if they are not entered by a certain date (deadline) I want the cells to be dis-abled and maybe an error message appear on screen as to why?

thx

0