If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula based on format of cell
How do I create a formula based on the format of a cell? For example, I want
to add up all values of the cells that are red. Can I do this? How? |
#2
|
|||
|
|||
Formula based on format of cell
You can't do this with a formula. It would have to be VBA.
http://xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/colors.aspx -- David Biddulph ant wrote: How do I create a formula based on the format of a cell? For example, I want to add up all values of the cells that are red. Can I do this? How? |
#3
|
|||
|
|||
Formula based on format of cell
The first link I tried but Excel said it was an incorret name. The second
link was way to hard to understand. I need something set out simply and clearly. "David Biddulph" wrote: You can't do this with a formula. It would have to be VBA. http://xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/colors.aspx -- David Biddulph |
#4
|
|||
|
|||
Formula based on format of cell
If Excel is telling you that you have an incorrect name, you have presumably
not correctly defined the ColorIndex UDF. If you are struggling to understand the links I gave you, then I guess you'll struggle with http://www.ozgrid.com/VBA/Sum.htm too. As I said, "You can't do this with a formula.". If you can't cope with the VBA you can't do it. -- David Biddulph ant wrote: The first link I tried but Excel said it was an incorret name. The second link was way to hard to understand. I need something set out simply and clearly. "David Biddulph" wrote: You can't do this with a formula. It would have to be VBA. http://xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/colors.aspx -- David Biddulph |
Thread Tools | |
Display Modes | |
|
|