Find all colored cells and sum all:
Here is a quick way without VBA or formulas.
Edit Find clear "Find What" Options Format
"Choose Format From Cell" select sample cell
Find All scroll to end of list, press CTRL+SHIFT
and click on the last entry of the list.
Right click Status Bar and check Sum.
HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"T. Valko" wrote:
Not directly. You'd need some VBA procedures.
See this:
http://www.cpearson.com/Excel/colors.aspx
I recommend not doing it this way.
Write a formula based on the logic of *WHY* the numbers are highlighted
green. If they're highlighted using conditional formatting then you should
be able to write a formula based on the conditional formatting logic.
--
Biff
Microsoft Excel MVP
"Fun Dan" wrote in message
...
Is it possible to use Sumif based on the cell's format? For example, I
want
to add up the numbers in a column that are highlighted green.