Cell validation based on values

Hello -

I have a worksheet with two cells that may contain data. The first cell (A1) may only contain a whole number while the second cell (B1) can only contain a date greater than today. However, only one of these two cells may contain a value. I need a procedure that enforces this validation:


If A1>=1, then B1 is null
If B1>=1,then A1 is null

Thanks for any assistance with this.

Grilleman

I would leave the data in A1 & B1 and add the formulas to C1 & D1 ---

Please Login or Register  to view this content.

So where would I insert this code... at the sheet level, the workbook level or the module level. Sorry, I's struggling to learn this.

Can't seem to get this to work quite right. With your code, when a value is entered in A1 B1 can still receive data. I want to prohibit this. Cell B1 should be locked when A1 contains data and cell A1 should be locked whenever cell B1 contains data.