This thread is a parallel of another similar thread (that was actually in two threads), see

http://google.com/groups?threadm=Oyk...GP14.phx .gbl

then see
http://google.com/groups?threadm=%23...GP12.p hx.gbl
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dtencza" wrote in message ...
Thanks, Duke. This looks like just what I need, especially this link:

http://www.cpearson.com/excel/CFColors.htm

How do I actually use these functions? I copied and pasted these functions
into the Visual Basic editor and hit Save. The functions still don't work,
though. I get the #NAME? error, which I think is because I didn't put them
in there the right way, so Excel doesn't recognize the function yet.

I am probably doing something wrong since I haven't tried to do something
like this before? Would you (or anyone else) know the right way to get these
functions?

Thank you for any help you can offer.


"Duke Carey" wrote:

See Chip Pearson's site

http://www.cpearson.com/excel/SortByColor.htm


"dtencza" wrote:

I have cells in a column, some colored yellow, some not. I am trying to use
the SUMIF function to sum only the cells in the range that are colored. Can
this be done? Can I enter something in the "criteria" part of the formula
that can do this?

=SUMIF(D3:D13,"criteria",D3:D13)

I also tried to use the CELL function's color feature, but I couldn't get it
to work right. I don't know how to get Excel to recognize if a cell is
colored in a formula.
=CELL("color",cell)

It might just be that I don't know what this means in Help:

"color" -- 1 if the cell is formatted in color for negative values;
otherwise returns 0 (zero).

Can anyone help?