Forum Discussion
Font color overrides table format template font color
I've worked on your file and on this matter about 2-3 hours. Interesting things. To start the discussion, I can say that if you format the table range with font color "[Black], Text 1" the table's format takes effect. I tested on various worksheets and on most of them this workaround was successful. But on one of them you have to choose the Automatic for font color for table range for the table's font color to take effect. On one worksheet, both didn't help, until I have clear formatting with the option in Home tab, Edit section, Clear.. options. In this last scenario, even "Right clicking on the desired Table Style and selecting "Apply (And Clear Formatting)" but on the previous worksheets this option was working and was setting the normal font color to "[Black], Text 1" not to "Automatic" but I thing on an weird worksheet it resetted it to "Automatic" also. All these are very intricate things, which are being effected by Themes colors applied on the workbook, normal font colors applied on the cells, even maybe on text (portions) inside a cell, table formatting etc. We should not waste our valuable time on these intricate things just to be ware of how things work on a software since it may be a result of a bug or even the working principals of softwares.
Edit: by the way, thank you for posting about this so that I could found 1 your discussion on the Internet when I encountered with this problem on my own file.