Customize the color of selected and highlighted cells

You can now customize the format of selected and highlighted cells by picking the color of the background and the border of the cells. You can also select a transparent background color, which allows you to view the original color of the active cells without overwriting the colors.

Previously, when you selected cells in the cube viewer, the color of the current selection is fixed and overwrites the original color of the cells, including any conditional and hierarchy formatting. This means that you cannot view the state of any cells that you selected or highlighted. In addition, the background color of the current selection or highlights might make the text difficult to read on the cells.

You can now customize the color of the background and the border of any cell that you select and any highlighted cell that is associated with the selected cells. To view the original colors of the selected and highlighted cells, select transparent as the background color for selected and highlighted cells.

To customize the format of selected and highlighted cells, follow these steps:

1. Select a view and click Format manager in the toolbar.
2. Click Data area on the View tab.
3. Under Selection styles, choose the colors you want for Selected background, Selected border, Highlighted background, and Highlighted border.

   To keep the original cell colors of the selected and highlighted cells, select transparent (no color) as the color for Selected background and Highlighted background.

4. Click Apply.