|
|||||||
![]() |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
#1 |
|
Member (5 bit)
Join Date: May 2004
Location: Connecticut
Posts: 19
|
Is this possible in Excel?
I was just wondering if there was a way for me to remove an entire row upon reaching a date two weeks after the posted date in a cell (the cell in the the row being removed). This row then needs to be moved into a new spreadsheet. If it is possible any ideas on how to achieve this would be appreciated.
|
|
|
|
|
|
#2 |
|
Member (8 bit)
Join Date: May 2000
Location: Ft. Riley, KS
Posts: 215
|
I believe this is possible using "conditional format".
|
|
|
|
|
|
#3 |
|
Member (8 bit)
Join Date: Sep 2004
Posts: 167
|
I dont get the example. to delete and move rows cells you may need a macro. Conditional format will only change the format (color/font size, etc ) of hte cell not actually remove it.
can you post a pic/text version of te spready? |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|