I have a worksheet that has a formula in all cells in column H that says if
there is a comment in column 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 column G it updates
all of my dates in column H.

Using Excel 2007