Add border based on date
 

How can I add a top border based on date found in column 1 which will run to
the right 8 columns? In other words, everytime a date is found in column a,
place a border across the top of that row.

(I know how to do this manually, I would like the macro to do this.) Using
win2000/office 2000

Thanks.

Add border based on date
 

Format/Conditional Formatting will enable this

--
Message posted from http://www.ExcelForum.com

Add border based on date
 

Can this be written into code so I can put it into a macro?


"BrianB " wrote in message
...
Format/Conditional Formatting will enable this.


---
Message posted from http://www.ExcelForum.com/