Am 01.11.2010 15:54, Fans OpenSource wrote:
Seems that's unique from Microsoft 2007, don't know on this function in Calc
till now.
Xiaoqi
Please tell me how you can do that in Excel 2007.
http://www.pcmech.com/forum/software-discussion-support/194498-excel-want-count-colors.html
Obviously, it is not implemented in the program. You have to write your
own macro to do this trick.
There are reasons why such a function is not built in. Not even in
Microsoft Excel.
Professional spreadsheet design requires a clear separation of data and
attributes.
In my previous message I provide a userdefined function to extract the
color code from the cell attributes which can help to repair badly
designed spreadsheets.
You can also go on like that and use that function together with
COUNTIF, SUMIF and all the other functions. It's completely up to you.
Greetings,
Andreas Säger
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
