Hey Stresssed

If you selected the whole of column J and then applied that formula in
data validation it won't work because the row references will be out of
sync (e.g. data validation for J1 will refer to row 2, validation in J2
will refer to row 3 etc.)

You need to just select J2:J500 and then copy in that formula


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=501528