Add line between previous and current cells . .

[Jeff Roper]

I am trying to add a line between the last selected cell and the current
cell (in the same column), and I don't know the syntax on that. The
recorded macro just went to the same spot every time and didn't move
along with the new data. What I'm really trying to do is to have the
worksheet automatically add a line between the previous cell and the
current cell, when a new month has been entered. Is it possible?


Ex:

| A | B |
|---------------|----------------|
1| 11/10/04 | |
--|---------------|---------------|
2| 12/01/04 | |
3| 12/05/04 | |
--|-------------------------------|
4| 01/05/04 | |

 

[keepITcool]

you could use conditional formatting for that.

select the column.
(i'll assume we're in cell A1

Format/Conditional formatting

in the DD select formula
in the box enter =month(a1)<>month(a2)
click the format button, assign the bottom border a nice line.

done.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Jeff Roper wrote :