| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Add border based on date
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| border on last cell of page effects border on beginning cell of ne | Excel Discussion (Misc queries) | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| add a border based on value in cell | Excel Worksheet Functions | |||
| Sumproduct based which also weights data based on date | Excel Worksheet Functions | |||
| Changing the border of one cell s/n change the border of adjacent | Excel Discussion (Misc queries) | |||
Linear Mode
