When a table uses a toggle item, such as the Expand/Collapse feature, the font color expression and the background color expression for the cell that contains the toggle item is not evaluated correctly.
For example, the font color of a cell that contains the toggle item is set by using expression ="Red" and background color ="Silver". In this example, the cell should be expandable by using red text and a silver background.
However, based on the value of the CanGrow property, the actual cell results may be different. This is described in the following table.
Font color expression is not evaluated.
Background color expression is evaluated.
False (toggle cell)
Cell has value and toggle. Background color expression is evaluated AND Font color expression is evaluated correctly.
False (all cells)
|Cell has value and toggle. Background color expression is evaluated AND Font color expression is evaluated correctly.|
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.