You can apply the formatting of the cell that you zoom in on to the cells that are created by zooming. For Smart View formatting, this ability applies to data cells. For Excel formatting, this ability applies to member cells.
To apply Smart View formatting selections to data cells created by zooming, from the Essbase, Planning Ad Hoc, or Hyperion Enterprise ribbon, select Preserve Format.
To apply Excel formatting selections to member cells created by zooming, from the Smart View ribbon, select Options. Then select all these options:
From the Formatting page, select Use Excel Formatting
From the Member Options page, select Preserve Formulas and Comments on Adhoc operation (except Pivot)
From the Member Options page, select Formula/Format Fill