+ Reply to Thread
Results 1 to 3 of 3

Clearing formats doesn't clear the background color

  1. #1
    Registered User
    Join Date
    04-25-2014
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2010
    Posts
    26

    Clearing formats doesn't clear the background color

    Hi all,

    This is quote from the "Microsoft Excel 2010 by Jahn Walkenbach" book:

    "Clearing formats doesn't clear the background color in a range that has been designated as a table unless you replace the table style background colors manually".

    But, When I create a table and right click -> format cells -> Fill -> background color and then chose a color then OK.
    After that I chose all cells of that table (which now has a background color) and the Clear->clear formats.
    But the background color also will be cleared. Why? The wrong is with my work or the book's text please?

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Clearing formats doesn't clear the background color

    Quote Originally Posted by abbassi View Post
    Hi all,

    This is quote from the "Microsoft Excel 2010 by Jahn Walkenbach" book:

    "Clearing formats doesn't clear the background color in a range that has been designated as a table unless you replace the table style background colors manually".

    .
    Please have a look at the bolded one
    Please make the Post as solved, when you get your answer & Click * if you like my suggestion

  3. #3
    Registered User
    Join Date
    04-25-2014
    Location
    Tehran, Iran
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Clearing formats doesn't clear the background color

    OK, what do you mean by that please? What step of my work isn't correct?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  2. Replies: 6
    Last Post: 11-07-2012, 10:46 AM
  3. [SOLVED] Macro to change all cells with a certain background color in another background color
    By kevinvzandvoort in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 11:04 AM
  4. [SOLVED] Clear a worksheet without clearing formulas?
    By doodah in forum Excel General
    Replies: 4
    Last Post: 01-02-2006, 04:59 PM
  5. [SOLVED] Change of text or background color doesn't change on the screen.
    By Susan in forum Excel General
    Replies: 5
    Last Post: 07-29-2005, 03:05 PM

Tags for this Thread

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