Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
formula based on format | Excel Discussion (Misc queries) |