Forum Discussion

Deman2000's avatar
Deman2000
Copper Contributor
Sep 14, 2022

PivotTable

Hello everyone. Who can help me to make in PivotTable report by filtering the values in the columns by color? I need to highlight in the PivotTable the sum of the indicators separately yellow...
excel
hansleroy's avatar
hansleroy
Iron Contributor
Sep 16, 2022

Hi,
No, you can't base a pivot table on colors. This is what I can think of:

 

  • You can filter by color
    Filter by font color, cell color, or icon sets
    https://support.microsoft.com/en-us/office/filter-by-font-color-cell-color-or-icon-sets-4af3e865-3e34-4d81-9814-1893ffaada3c
  • And work with SUBTOTAL that calculates only with the displayed values.
    SUBTOTAL function
    https://support.microsoft.com/en-us/topic/7b027003-f060-4ade-9040-e478765b9939
  • I've found some VBA code that pretends being able to calculate with colors, but I didn't test it: http://www.cpearson.com/excel/colors.aspx

Kind regards
Hans

Resources