My task/problem right now is to figure out how to group a large pool of data that has a lot of information in one cell.
For example, in column A-C will look like this:
10 pink balloons version 1
10 pink balloons version 2
12 blue balloons version 1

The number, color, and version are all important to me but grouped in the same column. Every week I got a large excel sheet emailed to me in this format and I would like to write a macro to sort it so that it is easily digestible. I have limited VBA programming knowledge, but so far what I was thinking was to record a macro with a bunch of different Conditional Formatting rules in order to color code the cells. From there I hope to sort the data based on the color of the cell.

Specifically, for all red cells in column A, I need to sum the values of their corresponding cell D. So if A1 and A20 are red, I need to sum D1 and D20..

All help is greatly appreciated.