Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum by cell color
Hi,
I need help creating a macro. I need to sum the values of cells which are a certain color. The catch is that the values also contain letters. The cells can contain values such as V1 or V.25. So, for an example, I would like to sum the numbers in all the purple cells. Any suggestions on how to accomplish this would be great. Thanks! -*k -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas based upon the color shading of a cell? | Excel Worksheet Functions | |||
How bring a color on cell from one sheet to another | Excel Discussion (Misc queries) | |||
The color in excel does not show up in the cell on screen | Excel Discussion (Misc queries) | |||
How do I connect cell color to bar chart color? | Charts and Charting in Excel | |||
Current Cell Color | Excel Worksheet Functions |