Restrict cell input until another cell is populated

[lesley burlingham]

I would like cell B32 to only be active once I48 has been populated with a date.

Once I48 is populated I only want to input a date greater than or equal to what was in I48.

 

[Abdul Matheen]

Hi Lesley,

To do this activity you need a VBA code, send me the workbook file i will do it for you.

Regards
Matheen

 

[Faseeh]

Please goto Data Validation > Custom > uncheck Ignore Blank and paste this formula in the same provided

=AND(ISBLANK(I48)=FALSE,B32>=I48,I48>0)

Hopefully it works.

 

[lesley burlingham]

Hi Lesley,

To do this activity you need a VBA code, send me the workbook file i will do it for you.

Regards
Matheen

 

[Somendra Misra]

Hi Lesley,

See this file, refer cell B32 & I48.

Regards,