Use conditional formatting to highlight information in Excel - Microsoft Support

Conditional formatting typically works the same way in a range of cells, an Excel table, or a PivotTable report. However, conditional formatting in a PivotTable report has some extra considerations: There are some conditional formats that don't work with fields in the Values area of a PivotTable report. For example, you can't format such fields based on whether they contain unique or duplicate val

[katsumushi]

Excelの条件付き書式でヒートマップ。