Pivot Table Question

I have a pivot table, in the "sum" column I have various dates. I have conditional formatting which makes certain dates green, yellow, and red.

The "sum" column consists of a few hundred dates each with their associated color.

I want to be able to count the cell by color. Currently I am having to manually count each color by hand, I want this to be automated.

I know you can count cells by color in a regular worksheet using VBA Color Function. For some reason, in a pivot table, I am unable to use color fuction to count each cell by color.

Any ideas on how I can accomplish this?

Thanks, let me know if you need further explanation.

I have attached a sample file... As you will see in the "Sum Column" I have dates with conditional formatting associated with each date.

I want to be able to automatically count each color in the pivot table. I can do this outside of the pivot, but for some reason it wont count the background color inside the pivot..

Let me know if this makes sense.

Thanks so much for your help... You have no idea how this will help automate things..

I found my new Excel forum!