See this:

http://www.mcgimpsey.com/excel/timestamp.html

--
Biff
Microsoft Excel MVP


"Penny Miller" wrote in message
...
I have a worksheet that has a formula in all cells in row H that says if
there is a comment in row G then put the current date/time in H(current
cell). My formula looks like the following in H5;

=IF(ISBLANK(G5),"",NOW())

The problem is that if I enter a comment in any cell in row G it updates
all of my dates in row H.

Using Excel 2007