View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
akantrow2 akantrow2 is offline
external usenet poster
 
Posts: 2
Default help with criteria and sum

thank you, Jacob....do you know where on this discussion group i could find
additional information on how to do that? i'm a novice at Excel. Thanks so
much!

"Jacob Skaria" wrote:

You will not be able to do that with worksheet functions; will have to
develop a macro which does this using the color index.

If this post helps click Yes
---------------
Jacob Skaria


"akantrow2" wrote:

Hi -
I would like to know how to make certain cells one color, other cells
another color, then sum those cells based on their color. Could someone
assist me on how to do that?
I'm using office 2007.
thank you!