View Single Post
  #8   Report Post  
Old December 31st 06, 07:21 PM posted to microsoft.public.excel.worksheet.functions
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default Color Cells Summing

Speaking of 2007... In Excel 2007 you can count by color, sum by color,
filter by color, sort by color and more.

--
Looking ahead,
Shane Devenshire


"Max" wrote:

Dave, thanks for the clarification.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
Just a comment about UDF's not working across workbooks.

If your UDF is in a workbook named Book1.xls, you can refer to a function
in
that workbook's project:

=book1.xls!ColorIndex(...)

If your UDF is in an addin, then you can refer to it just like it was
built into
excel.