Fortunately Excel doesn't have an inbuilt function to achieve this. I say
fortunately because in the view of many; including myself, it would be an
irritating distraction that would make me immediatly close the workbook.
Having got that off my chest and if you must do this then look here
Mike,
Thanks for that, it's not something i want to do, but i am at my wits end
trying to get people to enter correct infornation-at correct location in
spreadsheets!!!!!!