Problem with conditional formatting in pivot table (with more than 1270 rows). Excel 2013/2016
After adding conditional formatting to the pivot table with the format "format all cells based on their values", it works until the table is expanded to more than 1270 rows.
This problem occurs when the values are in rows, if the values in the columns, it works.
The problem was tested in Excel 2013/2016.
Sergei Baklan commented
Ekaterina, my guess that's by design limit. In your file the rule is applied to all Bonuses. When you expand the PivotTable actually the ApplyTo is converted to ranges "$F$9,$F$14,$F$19,$F$24,$F$29,$F$34,$F$39,$F$44,$F$49,..". I didn't google, most probably the limit on number of such ranges is 255. When you exceed the rule stops to work.