Results 1 to 1 of 1

Auto copy formatted cells to new worksheet

Threaded View

  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

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