hello, thank you for your reply.

i get an error message. i highlight the cells that i want, than i goto
data validation, custom and i then copy and past the formula u have
given me. when i click OK it says that the formula has an error in it.

please can you explain on how i should go about on solving this.

thank you


--
Maltenrazer
------------------------------------------------------------------------
Maltenrazer's Profile: http://www.excelforum.com/member.php...o&userid=16130
View this thread: http://www.excelforum.com/showthread...hreadid=275829