Clearing formats doesn't clear the background color

abbasi

Posts: 328   +24
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.
 
Back