Essbase uses this order of precedence when applying multiple text styles:
Linked object cells
Integration Server Drill-Through cells
Read-only cells
Read/write cells
Parent member cells
Child member cells
Shared member cells
Cells containing formulas
Dynamic calculation member cells
Attribute cells
Dimension cells
The only way you can apply a background color to data is to define a style for dimensions. If dimension styles are defined and the Use Styles setting is turned on, a background color is defined for members of a dimension.
The text styles that you can apply to members, dimensions, and data cells are hierarchical and determine which characteristics are applied. Member styles are at the top of the hierarchy. Thus, member styles are applied if styles are turned on.
If you want to see a child member style, ensure that the parent member style is turned off. If you want to see a shared member style, ensure that parent and child member styles are turned off.
For example, suppose you defined blue as the font color for linked objects and red for read-only cells. If a cell is tagged as a read-only cell and linked object cell, Essbase displays blue font color for the cell because the linked objects style overrides the read-only style.