View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Date Validation - Excel 2003

Select column G and Data ValidationAllowCustom

=$G1=$B1


Gord Dibben MS Excel MVP

On Mon, 22 Oct 2007 09:56:02 -0700, SiH23
wrote:

Hi,

The columns B and G in a spreadsheet are formatted to except date values in
the form: dd/mm/yyyy.

I need to set validation on Column G to only except a date that is either
equal to or greater than the date in Column B.

Any help or advice would be greatly appreciated.

Regards,

Simon.