## 3.4.1  SAP cell styles
## SAP standard styles
SAP standard styles are available after the installation. You can modify them in the Styles group on the Home tab in Microsoft Excel. They affect the formatting as described in the following table:
| Style Name           | Description                                                                                                            |
|----------------------|------------------------------------------------------------------------------------------------------------------------|
| SAPDimensionCell     | Format for dimension header cells.                                                                                     |
| SAPMemberCell        | Format for member cells (non-hierarchical dimensions).                                                                 |
| SAPHierarchyCell     | Format for hierarchical member cells (even levels 0, 2, ...).                                                          |
| SAPHierarchyOddCell  | Format for hierarchical member cells (odd levels 1, 3, ...) .                                                          |
| SAPMemberTotalCell   | Format for member total cells.                                                                                         |
| SAPDataCell          | Format for data cells.                                                                                                 |
| SAPDataRemoved       | Format for empty crosstab cells whose data was removed as the workbook property Remove Data Before Saving is selected. |
| SAPDataTotalCell     | Format for data total cells.                                                                                           |
| SAPExceptionLevel1-9 | Format for highlighted cells due to conditional formats (rule priorities 1-9).                                         |
| Style Name               | Description                                                                                                                                                                                                                                                                                                          |
|--------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| SAPEmphasized            | Format for highlighted data cells (as per query definition).                                                                                                                                                                                                                                                         |
| SAPEmphasizedTotal       | Format for highlighted total cells (as per query definition).                                                                                                                                                                                                                                                        |
| SAPBorder                | Format for borders around a crosstab and between header/ member and data cells (format for left border is taken). After changing this style, for example the color, you have to execute Refresh All in the Analysis ribbon to apply the changes.                                                                     |
| SAPMessageText           | Format for the message that is displayed whenever a crosstab cannot be rendered and displayed in the sheet.                                                                                                                                                                                                          |
| SAPFormula               | Format for inserted single cell fomulas: Insert Filter and Insert Info Field (Data Source Name, Last Data Update and Key Date). The fomat is not applied for array formulas (Insert Info Field for Effective Filters or Variables) and for fomulas inserted directly into the sheet (manual or as MSExcel function). |
| SAPGroupingFillCell      | Format for header fill cells when grouping crosstabs.                                                                                                                                                                                                                                                                |
| SAPEditableDataCell      | Format for input-ready data cells in planning change mode.                                                                                                                                                                                                                                                           |
| SAPEditableDataTotalCell | Format for input-ready total cells in planning change mode.                                                                                                                                                                                                                                                          |
| SAPReadonlyDataCell      | Format for read-only data cells in planning change mode.                                                                                                                                                                                                                                                             |
| SAPReadonlyDataTotalCell | Format for read-only total cells in planning change mode.                                                                                                                                                                                                                                                            |
| SAPLockedDataCell        | Format for locked data cells in planning change mode.                                                                                                                                                                                                                                                                |
| SAPLockedDataTotalCell   | Format for locked total cells in planning change mode.                                                                                                                                                                                                                                                               |
## SAP custom styles
The following SAP custom styles are not availabe after the installation, but you can create them in the Styles group on the Home tab of Microsoft Excel. They affect the formatting as described in the following table:
| Style Name           | Description                                                                                                   |
|----------------------|---------------------------------------------------------------------------------------------------------------|
| SAPMemberCellX       | Format for member cells on columns (overriding SAPMemberCell).                                                |
| SAPMemberTotalCellX  | Format for member total cells on columns (overriding SAPMemberTotalCell).                                     |
| SAPHierarchyCellX    | Format for hierarchical member cells on columns, even levels (overriding SAPHierarchyCell).                   |
| SAPHierarchyOddCellX | Format for hierarchical member cells on columns, odd level (overriding SAPHierarchyOddCell).                  |
| SAPHierarchyCell0-9  | Format for hierarchical member cells on specific level (overriding SAPHierarchyCell and SAPHierarchyOddCell). |
## Style Name
| SAPHierarchyCell0-9X   | Format for hierarchical member cells on specific level on columns (overriding SAPHierarchyCellX and SAPHierarchyOddCellX).   |
|------------------------|------------------------------------------------------------------------------------------------------------------------------|
## Example: SAPMemberCellX
The column headings are defined as SAPMemberCell. If you want a different format for these cells than for member cells in rows, you can duplicate the SAPMemberCell, name it SAPMemberCellX and change the format definition. If you save this as style set, the member cells in column headings are displayed in the new defined format. The member cells in rows continue to be displayed as defined in the SAPMemberCell style.
## Example: Styles for Hierarchy Levels
The standard styles for hierarchies are SAPHierarchyCell and SAPHierarchyCellOdd. With these styles, the hierarchy levels have alternating styles. If you want to have three different styles for the first three hierarchy levels of an hierarchy, create the styles SAPHierarchyCell0, SAPHierarchyCell1 and SAPHierarchyCell2. The system ignores the standard styles and applies the styles for specific styles. If an hierarchy have more than three levels, the levels after level 2 are displayed with the SAPHierarchyCell2 style.