conditional formatting excel 2016 within a formula

The default method of scoping fields in the Values area is by selection. There are three methods for scoping the conditional format of fields in the Values area: by selection, by corresponding field, and by value field.

Note: In the data hierarchy, children do not inherit conditional formatting from the parent, and the parent does not inherit conditional formatting from the children. 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.

Conditional formatting excel 2016 within a formula