+ Reply to Thread
Results 1 to 1 of 1

Auto copy formatted cells to new worksheet

  1. #1
    Registered User
    Join Date
    06-19-2010
    Location
    texas, usa
    MS-Off Ver
    Excel 2010
    Posts
    24

    Auto copy formatted cells to new worksheet

    When I insert a date in column A the corresponding cell in Column D turns red. When I insert a completion date in Column D the cell reverts to white. What I want to do is have a way to automatically copy any row with a red cell from the 'Started' worksheet to the 'Not Completed' worksheet, that is so I can look at at the "Not Completed" worksheet at any time and see what is not finished. Also, is the way that I did the conditional formatting for the cell to turn red and revert to white the best way to do it? Any help appreciated.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1