Results 1 to 8 of 8

Thread: Macro to clear data based on color fill

Threaded View

Howardc Macro to clear data based on... 11-28-2012, 11:20 AM
Admin Hi try this. Sub... 11-28-2012, 05:18 PM
Howardc Thanks for the help, much... 11-28-2012, 07:00 PM
Howardc Hi admin I would like to... 11-28-2012, 08:00 PM
Admin Hi Try to modify yourself... 11-28-2012, 09:27 PM
Howardc Hi Admin Thanks for the... 11-28-2012, 09:36 PM
Admin Thanks for the feedback. ... 12-03-2012, 08:59 AM
Howardc Thanks for the links. i'm... 12-03-2012, 09:25 AM
Previous Post Previous Post   Next Post Next Post
  1. 11-28-2012, 11:20 AM #1
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    14

    Macro to clear data based on color fill

    I would like code to clear data on all sheets from row 5 onwards where the data has been colored using the color fill, except formulas-see sample data attached

    Your assistance is most appreciated.

    I have also posted on Mr Excel.com-see link below


    Macro to clear data
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Macro To Update Data in Cell Based On Value In Adjacent Cell
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 05-30-2013, 07:28 PM
  2. Clear Specific Rows Of Data On Multiple WorkSheets
    By Howardc in forum Excel Help
    Replies: 9
    Last Post: 12-04-2012, 09:45 PM
  3. Macro To Clear Certain Data Across Many Sheets
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 12-04-2012, 09:10 AM
  4. Macro to check values based on certain text
    By Howardc in forum Excel Help
    Replies: 25
    Last Post: 11-05-2012, 09:03 PM
  5. Color Cell Fill With Conditional Format When Value Less Than Or Greater Than X
    By Oh!Calcutta in forum Excel Help
    Replies: 4
    Last Post: 07-27-2012, 08:43 AM

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
  •  

Forum Rules