Ask Your Question

counting cells based on color [closed]

asked 2013-01-18 17:09:48 +0200

ben_says gravatar image

I have a calendar built, and I would like to be able to fill cells with a color and have a way to count the number of cells that have that color.

So, in a defined range filled with, for example, red (representing vacation days) how can I sum all cells filled with red.

This is helpful as I can slowly fill in all vacation days, holidays, then half or quarter vacation days, and quickly move them around and see where my total remains after different iterations.

Thanks for your time.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 13:59:05.911949

1 Answer

Sort by » oldest newest most voted

answered 2013-01-18 22:38:55 +0200

m.a.riosv gravatar image

Hi @ben_says, no function implemented to do it. And I think it is not always a good approach to do it, i.e. a little difference in the colour do not get the cell. I think much better, clear and easy to mantaing, using another column to set what you want, and with conditional formatting set up the cell colour.

But you can find a solution on this thread in Aoo forum, where several introspective functions are developed in star basic (macros), and one of them gives the background colour.
Calc, Basic: Introspective cell functions

edit flag offensive delete link more

Question Tools


Asked: 2013-01-18 17:09:48 +0200

Seen: 6,902 times

Last updated: Jan 18 '13