Font color overrides table format template font color

%3CLINGO-SUB%20id%3D%22lingo-sub-1767583%22%20slang%3D%22en-US%22%3EFont%20color%20overrides%20table%20format%20template%20font%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1767583%22%20slang%3D%22en-US%22%3E%3CP%3ENo%20matter%20what%20normal%20font%20color%20do%20I%20set%2C%20it%20will%20override%20any%20table%20format%20template.%3C%2FP%3E%3CP%3EBy%20%22normal%22%20I%20mean%20the%20format%20we%20set%20NOT%20using%20any%20special%20tricks%20like%20conditional%20format%20or%20table%20template.%3CBR%20%2F%3EThis%20is%20not%20about%20conditional%20formatting%2C%20even%20though%20I%20use%20that%2C%20too.%20Two%20other%20types%20of%20formatting%20clash%3A%20the%20normal%20settings%20vs%20table%20format%20templates%20(any%2C%20whether%20built%20in%20or%20custom).%3C%2FP%3E%3CP%3EMy%20table's%20range%20(B2%3AK22)%20is%20not%20only%20formatted%20differently%20by%20a%20custom%20table%20format%20template%2C%20but%20the%20same%20range%20also%20has%20a%20different%20%22normal%22%20format%20than%20the%20area%20surrounding%20it.%3C%2FP%3E%3CP%3EAnd%20there%20is%20no%20way%20I%20can%20apply%20the%20white%20(or%20any%20other)%20font%20color%20of%20any%20table%20format%20template.%3C%2FP%3E%3CP%3ENormal%20format%20settings%20i.e.%20NOT%20the%20table%20template%20on%20the%20worksheet%3A%3CBR%20%2F%3E-%20table%20range%20is%20with%20%22no%20color%22%20of%20background%20(fill)%20and%20I%20tried%20various%20colors%20for%20font%2C%3CBR%20%2F%3E-%20surrounding%20area%20(not%20B2%3AK22)%20is%20with%20white%20font%20and%20black%20background.%3C%2FP%3E%3CP%3EI%20don't%20change%20that%2C%20and%20then%20a%20table%20format%20template%20is%20set%20for%20the%20table%20range.%3C%2FP%3E%3CP%3EPreviously%20I%20had%20black%20background%20(normal%20format)%20in%20the%20table%20range%2C%20too.%20That%20caused%20the%20table%20format%20template's%20background%20color%20to%20be%20ignored.%3CBR%20%2F%3EThen%20I%20set%20the%20normal%20format%20of%20cell%20background%20to%20%22no%20color%22%2C%20and%20this%20allowed%20the%20table%20format%20template%20(alternating%20color%20of%20rows)%20background%20to%20take%20effect.%3C%2FP%3E%3CP%3EBUT%20in%20normal%20format%20settings%20there%20is%20no%20such%20option%20as%20%22no%20color%22%20for%20font%2C%20that%20choice%20exists%20only%20for%20background%20(fill)%20color.%3CBR%20%2F%3ESo%2C%20in%20normal%20format%20settings%20(not%20table%20format%20template)%20I'm%20forced%20to%20choose%20a%20font%20color%3A%20automatic%2C%20black%2C%20white%20whatever.%3C%2FP%3E%3CP%3EAnd%20that%20choice%20overrides%20ANY%20table%20format%20template's%20font%20color%2C%20whether%20it%20is%20a%20built%20in%20or%20custom%20template.%3C%2FP%3E%3CP%3EMy%20custom%20table%20format%20template%3A%3CBR%20%2F%3E-%20white%20font%20color%20in%20ALL%20sub%20parts%20of%20the%20template%3A%20title%2C%20results%2C%20first%20and%20second%20row%2C%20entire%20table%20and%20also%20in%20all%20kinds%20of%20column%20specification%2C%3CBR%20%2F%3E-%20either%20very%20dark%20or%20black%20background%20(fill)%20colors%20(depends%20on%20part%20of%20table%20and%20row%20index).%3C%2FP%3E%3CP%3EI%20thought%2C%20if%20I%20choose%20%22automatic%22%20font%20color%20in%20the%20normal%20format%20settings%2C%20that%20would%20let%20the%20table%20format%20take%20effect%2C%20but%20it%20doesn't.%3CBR%20%2F%3EIt's%20just%20black%2C%20so%20there's%20no%20point%20calling%20it%20automatic.%3C%2FP%3E%3CP%3EThis%20means%20I%20can't%20use%20any%20table%20format%20template%20with%20alternating%20font%20color%2C%20and%20if%20I%20pick%20one%20with%20just%20one%20font%20color%20I%20still%20have%20to%20set%20the%20font%20color%20manually%20to%20match%20the%20template.%3C%2FP%3E%3CP%3EThis%20is%20true%20for%20the%20title%20row%2C%20too%2C%20so%20forget%20templates%20with%20two%20font%20colors%20anywhere%20on%20a%20table...%3CBR%20%2F%3ECan%20I%20make%20table%20templates%20work%3F%3CBR%20%2F%3EWindows%208.1%2C%20MS%20Office%20365%2C%20Excel%202013%20(15.0.5267.1000)%2032-Bit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1767583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

No matter what normal font color do I set, it will override any table format template.

By "normal" I mean the format we set NOT using any special tricks like conditional format or table template.
This is not about conditional formatting, even though I use that, too. Two other types of formatting clash: the normal settings vs table format templates (any, whether built in or custom).

My table's range (B2:K22) is not only formatted differently by a custom table format template, but the same range also has a different "normal" format than the area surrounding it.

And there is no way I can apply the white (or any other) font color of any table format template.

Normal format settings i.e. NOT the table template on the worksheet:
- table range is with "no color" of background (fill) and I tried various colors for font,
- surrounding area (not B2:K22) is with white font and black background.

I don't change that, and then a table format template is set for the table range.

Previously I had black background (normal format) in the table range, too. That caused the table format template's background color to be ignored.
Then I set the normal format of cell background to "no color", and this allowed the table format template (alternating color of rows) background to take effect.

BUT in normal format settings there is no such option as "no color" for font, that choice exists only for background (fill) color.
So, in normal format settings (not table format template) I'm forced to choose a font color: automatic, black, white whatever.

And that choice overrides ANY table format template's font color, whether it is a built in or custom template.

My custom table format template:
- white font color in ALL sub parts of the template: title, results, first and second row, entire table and also in all kinds of column specification,
- either very dark or black background (fill) colors (depends on part of table and row index).

I thought, if I choose "automatic" font color in the normal format settings, that would let the table format take effect, but it doesn't.
It's just black, so there's no point calling it automatic.

This means I can't use any table format template with alternating font color, and if I pick one with just one font color I still have to set the font color manually to match the template.

This is true for the title row, too, so forget templates with two font colors anywhere on a table...
Can I make table templates work?
Windows 8.1, MS Office 365, Excel 2013 (15.0.5267.1000) 32-Bit

0 Replies