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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]submit date[/TD]
[TD]recived date[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 135"]
<tbody>[TR]
[TD="class: xl77, width: 135"]16-Feb-13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<tbody>[TR]
[TD="class: xl77, width: 132"]8-May-13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 135"]
<tbody>[TR]
[TD="class: xl77, width: 135"]6-Nov-13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<tbody>[TR]
[TD="class: xl77, width: 132"]20-Jun-13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 135"]
<tbody>[TR]
[TD="class: xl77, width: 135"]5-Jan-13[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 267"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 132"]
<tbody>[TR]
[TD="class: xl77, width: 132"]4-Sep-13[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Note: Received date colum should only take dates that are greater then submitted date,if its less than submit date then its should prompt error or doesn’t insert or any message
1st is correct, 2nd value should give error as jun 13 is less then submit date.

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

urgently needed, will appreciate your reply!!

 

[Arul.rajesh]

You can use data validation. data>validation>custom Formula .While the data in column "B" is selected. "=A2><a2 while="" data="" in="" column="" "b"="" is="" selected.
B2"

Regards,
Arul</a2>