+ Reply to Thread
Results 1 to 4 of 4

Delete Row Based On Conditional Formatted Cell

  1. #1
    Registered User
    Join Date
    04-08-2010
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    10

    Delete Row Based On Conditional Formatted Cell

    Hi Guys,

    i'm trying to find a macro that i can run for a sheet with +40,000 rows, i have a few conditional formats in a certain column that highlights different account numbers; based on those results, i want to be able to delete the rows that have certain highlights (conditional formatting) - in Excel 2007, the different options i have both colors the font and the cell.

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Delete Row Based On Conditional Formatted Cell

    Hi,

    You would make your life a lot easier if you were to use the initial conditions you have used for the formats instead of the cell fonts or cell colors ... to code your macro ...

    HTH

  3. #3
    Registered User
    Join Date
    04-08-2010
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Delete Row Based On Conditional Formatted Cell

    Hi,

    it makes sense but the data is huge and i needed to make distinction between the rows based on the accounts on that column.

  4. #4
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Delete Row Based On Conditional Formatted Cell

    If you can get your conditions straight with clear rules, the data can be tiny, medium or huge ...it does not matter ...

    HTH

+ 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