+ Reply to Thread
Results 1 to 4 of 4

Aler this code to clear format cell color below rows...

  1. 01-10-2015, 09:50 AM #1
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Aler this code to clear format cell color below rows...

    HI,

    How can I alter this code 
    Please Login or Register  to view this content.
    So that the format of the cell color goes back to normal? It only clears the info, not the cell color...

    Please advise
    Reply With QuoteRegister To Reply
  2. 01-10-2015, 09:54 AM #2
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Aler this code to clear format cell color below rows...

    Will this work?
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  3. 01-12-2015, 10:26 AM #3
    swade730 is offline
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Aler this code to clear format cell color below rows...

    Quote Originally Posted by gmr4evr1 View Post
    Will this work?
    Please Login or Register  to view this content.
    this doesn't work
    Reply With QuoteRegister To Reply
  4. 01-12-2015, 10:42 AM #4
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Aler this code to clear format cell color below rows...

    Maybe:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Format cell color from bar code scan
    By jndipworm in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2014, 01:45 PM
  2. Clear cell with text in green color
    By gibtoul in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2013, 04:21 PM
  3. vba code clear cells by color font dark blue
    By etheer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-14-2012, 08:29 AM
  4. how do i format a cell to deciper dates and color code the results
    By Troy D in forum Excel General
    Replies: 1
    Last Post: 04-26-2010, 08:14 AM
  5. [SOLVED] excel: How can I color code rows based on a value in a cell?
    By Parker1333 in forum Excel General
    Replies: 2
    Last Post: 02-01-2005, 07:06 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1