I do not think i understand what you are trying to do. You can have a
pick box that displays yes or no, and change it to yes when you have
finished the job. I use a spreadsheet that tracks audit actions, the
last column is "date action closed out". As soon as this cell is
populated with a valid date, every cell in that row turns green by the
use of conditional formatting.

Hope this helps.

Bobf


--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=495159