Data validation?

[ellechim]

Hi Guys,

I have a question regarding the below scenario:

I have a worksheet with 0's and 1's as data, then the date as header. If the input is 0, it will display FAILED on the remarks, otherwise, PASSED. Just like on the data shown below.

Ex: 06-Mar-10 Remarks
1 PASSED
0 FAILED
0 FAILED
1 PASSED


The user can only input 0 or 1. I already do that using the data validation. But the problem is, if im going to change the date (06-Mar-10), the user will not be able to input any data on it's column (0 or 1).

I hope you can help me on this.

Thank you.

[Charlie_Howell]

Is this what you're looking for?

[ellechim]

Thanks sir for your reply but on you attached file im not going to use drop down. If I'm going to change the date, i will not be able to input/change anything on the column.

[Charlie_Howell]

I guess I don't understand...can you upload your sheet?

[ellechim]

here's the attachment sir

[noexcel=badwork]

you can protect the date cells, so that the user can't change the date in it
attached the file
try to change the date, system will not accept
hopefully this will solve your problem
thank you

[ellechim]

The condition is that it will still allow the user to change the date. But still, if the date changed, the user will not input anything on the column

[Charlie_Howell]

Sub Macro1()

Selection.Locked = False
Selection.FormulaHidden = False
Application.Goto Reference:="Area_1"
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
End Sub

[ellechim]

is there any solution aside from using macro?