The scope of the conditional format for fields in the Values area can be based on the data hierarchy and is determined by all the visible children (the next lower level in a hierarchy) of a parent (the next higher level in a hierarchy) on rows for one or more columns, or columns for one or more rows. If you change the layout of the PivotTable report by filtering, hiding levels, collapsing and expanding levels, or moving a field, the conditional format is maintained as long as the fields in the underlying data are not removed. These restrictions are mentioned in the remaining sections of this article, where applicable. For example, you can't format such fields based on whether they contain unique or duplicate values. There are some conditional formats that don't work with fields in the Values area of a PivotTable report. However, conditional formatting in a PivotTable report has some extra considerations:
Conditional formatting typically works the same way in a range of cells, an Excel table, or a PivotTable report.
0 kommentar(er)
