Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 292
- Office Version
- 365
- Platform
- Windows
I am unsure of how to explain this but I will do my best!
I currently utilize a module that can count and sum based on the color of a cell or the font. It works wonders
.
Whenever that information is "summed" up on my excel sheet, I want to be able to have a pop-up that when the cell is selected, the msgbox will show all of the parts that were of the same color.
Here is my thoughts:
<tbody>
</tbody>
Let's say the "Total" Column is highlighted "red" for "Apple" and "Banana".
Whenever the cell that has $25 in it is selected a pop-up msgbox would have the information such as:
Data to get Sum:
4 Apples at $5 = $20
and
$20 bananas at $0.50 = $10
I hope this all makes sense.
Thank you for any help!
I currently utilize a module that can count and sum based on the color of a cell or the font. It works wonders
HTML:
https://www.ablebits.com/office-addins-blog/2013/12/12/count-sum-by-color-excel/comment-page-2/
Whenever that information is "summed" up on my excel sheet, I want to be able to have a pop-up that when the cell is selected, the msgbox will show all of the parts that were of the same color.
Here is my thoughts:
Part | Qty | Price | Total |
Apple | 4 | $5 | $20 |
Pear | 7 | $1 | $7 |
Banana | 20 | $0.50 | $10 |
Orange | 5 | $1 | $5 |
Sum of "Red" | $25 |
<tbody>
</tbody>
Let's say the "Total" Column is highlighted "red" for "Apple" and "Banana".
Whenever the cell that has $25 in it is selected a pop-up msgbox would have the information such as:
Data to get Sum:
4 Apples at $5 = $20
and
$20 bananas at $0.50 = $10
I hope this all makes sense.
Thank you for any help!