http://www.j-walk.com/ss/excel/tips/tip99.htm
you could color all the cells, then use the macro from the above site
to select the unlocked cells then press no fill and it will clear.
If you have unlocked cells, then you protect your sheet, all the user
has to to is press the tab key when they make an entry and they will be
taken to the next unlocked cell
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=573537