Am 30.10.2010 00:29, Phil Pinkerton wrote:
I found a way to do this using MS Excel 2007 and was looking for a way
to do the same in OpenOffice Calc.
Anyone had success with counting of cells of a particular color ?
Phil
Phil,
How do you do this in Excel?
Are you really sure that Excel can do that without macro programming on
your own risk?
Could it be that there is a reason why this featue is not built into any
spreadsheet on the market?
Things are much easier AND reliable when you tag your data by means of
values rather than formatting.
Then you can apply conditional formatting to highlight your cells and
you can apply the very same conditions for calculation (counting,
summing, ...).
For instance, you can color all cells in all rows where the column named
"Comments" is not empty while COUNTA(Comments) counts the contents (and
the colored rows).
I wrote some cell functions in Basic to extract formatting properties.
The main intention is fixing badly designed sheets where information is
hidden in attributes rather than values.
It contains a function CELL_BACKCOLOR.
http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=2762
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
