cell lock

[bam12]

it here way to lock a cell when a certain date is meet with a formula, so that no info can be entered in it?

 

[Peter_SSs]

it here way to lock a cell when a certain date is meet with a formula, so that no info can be entered in it?

There probably is but you would need to spell this out more clearly. I don't know what you mean by "when a certain date is meet with a formula".

 

[bam12]

answer

What i meant is this

in cell C4i have a date let say 5/1/1994

in d1

I dont want to ba able to enter data in this cell when today date is eqaul to or greater then C4

i have seen VBA for this but was wondering if able to do with a formula

 

[Peter_SSs]

Try this:
1. Select D1
2. Data|Validation...|Settings|Allow: Custom|Formula:

=TODAY()<C4|OK

Note: If you want to apply similar Data Validation to a lot of cells then it would be better to put the formula =TODAY() into a blank cell somewhere (say Z1) then in the Data Validation Formula use something like

=$Z$1<C4

 

[shippey121]

try

DATA >> VALIDATION

select DATE then is less than and enter =C4 in the end date

you can then use the input and error alerts box to enter information

HTH

 

[bam12]

question

how about if i want it to lock on the next occurrance of 5/1, which would be 2007

 

[shippey121]

just alter the part in PeterSSS formula from <C4

to

=TODAY()<5/1/2007

 

[Peter_SSs]

.. or if you want the next occurrance based on what is in C4:

1. If you have Analysis ToolPak installed try =TODAY()<EDATE(C4,12)

2. If you do not have Analysis ToolPak installed and don't want to install it, then try =TODAY()<DATE(YEAR(C4)+1,MONTH(C4),DAY(C4))

Note: To check if you have Analysis ToolPak: Tools|Add-Ins... and see if Analysis ToolPak is ticked. If not, do so, and click OK.