How to compare two coloumns and restrict it values to be entered

[saber]

Dear experts please help

I have two column submit date and recived date in excel 2010, I want to put restriction on recivd date coloum.

submit date recived date
16-Feb-13
8-May-13
6-Nov-13
20-Jun-13
5-Jan-13
4-Sep-13

Note: Received date colum should only take dates that are greater then submite date,if its less than submit date then its should prompt error or doesn’t insert or any message

can any body give me the code for this (macro or formula).

please write reply in easy way that i can understand..

urgently needed, will appreciate your reply!!

 

[Mike H..]

Dear experts please help

I have two column submit date and recived date in excel 2010, I want to put restriction on recivd date coloum.

submit date recived date
16-Feb-13
8-May-13
6-Nov-13
20-Jun-13
5-Jan-13
4-Sep-13

Note: Received date colum should only take dates that are greater then submite date,if its less than submit date then its should prompt error or doesn’t insert or any message

can any body give me the code for this (macro or formula).

please write reply in easy way that i can understand..

urgently needed, will appreciate your reply!!

Hi,

select the topmost cell in the 'Received' column then drag to select as many cells as you want this to apply to then

Data tab | Data validation | Change the 'Allow' box to whole number, Change the 'Data ' box to Greater than or equal to'

Now in the 'Minimum' box type =A2 and ok out

Note that this assumes B2 was the topmost cells you selected in the received column.

See the attached workbook.