+ Reply to Thread
Results 1 to 6 of 6

Delete any row WITHOUT a fill color

  1. #1
    Registered User
    Join Date
    05-12-2011
    Location
    richmond
    MS-Off Ver
    Excel 2003
    Posts
    3

    Delete any row WITHOUT a fill color

    -My spreadsheet has data in the following columns/rows A7:K25000 & N7:W25000
    -Conditional formatting identifies integers 80 or greater and turns them yellow or read (depending on the number)(not the font, but the background)
    -All rows are evaluated by conditional formatting. 80-90 = yellow 90+=red
    -If just one cell on a row IS shaded (>80) then the entire row is to be left alone. If ALL cells on a row are (<80) NOT shaded then the entire row is to be delete.

    I need to delete any row that is completely without a background. The would be all the way from column A to Column W.

    Thanks in advance for the professional and well intentioned responses!

    HERE IS AN EXAMPLE OF MY SPREADSHEET.
    4/1/2011 0:01 =COLUMN A
    9.98 =COLUMN B
    0.82 =COLUMN C
    11.77 =COLUMN D

    4/1/2011 0:01 9.98 0.82 11.77 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:03 1.91 1.67 0.53 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:04 0.25 0.48 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:06 8.68 0.93 8.27 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:08 92.32 90.17 88.28 <<--80+ which would be yellow/red (DONT DELETE ROW!)
    4/1/2011 0:09 0.33 0.80 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:11 11.2 80.7 015.74 <<--80+ which would be yellow (DONT DELETE ROW!)
    4/1/2011 0:13 2.27 1.23 0.19<<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:14 0.23 0.38 <<-Need this row deleted AND moved up (because no color)
    4/1/2011 0:16 10.2 60.6 12.54 <<-Need this row deleted AND moved up (because no color)
    Attached Files Attached Files
    Last edited by aorum; 05-12-2011 at 03:44 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: MACRO: How to delete any row WITHOUT a fill color (background color)?

    Hello aorum,

    Welcome to the Forum!

    Do you have a workbook that can be used for testing the code on? If so, please post it.

    To Attach a File:
    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete any row WITHOUT a fill color

    Conditional Formatting to change a color and telling a macro to recognize that color doesn't work too well as far as i know. With that in mind it might be best to look at the value rather than interior color.

    Maybe try:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Delete any row WITHOUT a fill color

    After looking at your spreadsheet this might be a better way.

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Delete any row WITHOUT a fill color


  6. #6
    Registered User
    Join Date
    05-12-2011
    Location
    richmond
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Delete any row WITHOUT a fill color

    This is NOT a duplicate post.

    One post is WITH color, the other post is WITHOUT.

+ 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