Use the worksheet menu Data - Validation - custom


the formula in the Validation should return either a TRUE (can enter
datat into cell) or FALSE (cannot enter data into cell)


So you formula can look like this

Put this formula in cell W1 data validation. I assumed that the cells
can't equal 1.5
=if(I1=1,Or(W1=1,W1=2,W1=3,W1=4,W1=5),W1=0)


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161612

Microsoft Office Help