+ Reply to Thread
Results 1 to 3 of 3

Delete Color Filled Cells

  1. #1
    Registered User
    Join Date
    05-11-2007
    Posts
    7

    Delete Color Filled Cells

    I am looking for a way (Most likely a macro) to delete rows that contain filled cells. Is there a way to sort filled (cells with a filled color, in my case yellow) cells? I would like to delete all rows that contain a filled cell and it seems stupid for me to have to manually go through the entire worksheet and attempt to find and delete all the rows that contain filled cells.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    Have a look at the download example on my home page for a starting point.
    Martin

  3. #3
    Registered User
    Join Date
    05-11-2007
    Posts
    7
    I guess what I am really asking is if there is an automatic way to do this. I wouldnt mind having to sort by color first and then deleting the ones I dont need. but I dont really want to take the time to code something like this.

+ 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