Results 1 to 8 of 8

Thread: Macro to clear data based on color fill

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-28-2012, 11:20 AM #1
    Howardc
    Howardc is offline
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    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