...
For example, imagine you have more than one condition applied to the same format element: red text for all stores over 20,000 square feet, and blue text for all stores over 30,000 square feet.
Hierarchy | Result |
|---|---|
|
|
|
|
Condition Button States
Because conditions higher up in the hierarchy can affect those below, the font style selection buttons each have three states:
...
By default, the buttons are in the "Unchanged" state. Clicking the buttons toggles you through the three states.
Style Button States
The background and font color pickers have buttons for similar states, but these states behave slightly differently:
- Unchanged, which means the field inherits the previous condition-based color, if any.
- Set, which means the color is applied to text or background of the field that meets the condition.
- No Fill (background only), which means no color is applied to the background that meets the condition. Regardless of conditions lower in the hierarchy, the background inherits the table's default color.
Both have two buttons at the top of the window, along with the color selection boxes.
You control these states through the background color picker and the font color picker windows, using the following buttons:
- No Fill (background only), which applies the No Fill state described above.
- Reset, which returns the text or background to the Unchanged state.
- The color selection boxes, which apply the Set state.
Color Picker Button States
Unchanged | Set | No Fill | |
Background Color |
|
|
|
Text Color |
|
| N/A |
