Excel, Clearing formats doesn't clear the background color

[Franky]

Hi all,

This is quote from the "Microsoft Excel 2010 by John 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.

 

[Ranger4]

I cannot see why Clearing cell formats would not clear the Colour formats as well. This would be the logical approach & also why would you want the cell colour remaining if you have cleared the cell format.

I suspect that your 2010 manual may have an error & not your work.

 

[Franky]

Thanks for your opinion.

 

[TanyaC]

Hi,

Perhaps the reference is to the "Table Style". When clearing formatting on table styles, the style remains and that includes background colors.

Create a table and then click on a cell. From the "Table Styles" ribbon option, you can select a table style. Click the down arrow for a full list of styles.

What you describe doing yourself was to manually modify the properties of the cells; That is; the background color.

When you clear formatting in that case, you clear the manually formatted cell backgrounds.

hth
Tanya

 

[Franky]

Hi Tanyac,
I also tried that (although the meaning of the author hadn't been this I think) but clear format again removes the style and its color!