Page 1 of 1

[Solved] Counting Types of Formatted Cells

PostPosted: Sun May 18, 2008 10:18 pm
by Milligan
Hello,
hope this makes sence...
I've got OOo version 2.1 and I'm running it on Windos

I've got obsessed with tyring to do the following and am currently insisting to all of my household that it's possible, although we can't work out how....

I've defines some format styles for cells given them names (for example GB is a cell with a green backgound, RB is with Red BB is blue)

now I've essentialy used this to colour in some of the cells, and wonder if there is a formula that will tell me how many cells have been assigned with a certain style, GB for sake of argument.

I can't work out what formuals to use or if infact i can actually do this. HELP PLEASE, before my husband leaves me!

Re: Counting Types of Formatted Cells

PostPosted: Sun May 18, 2008 11:05 pm
by Hagar Delest
See if the macro linked in that thread helps: Does Calc Have a Data Verification/List Option?

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.

Re: Counting Types of Formatted Cells

PostPosted: Sun May 18, 2008 11:17 pm
by Villeroy
All calculations are based on cell values rather than formatting. Furthermore you can apply formatting based on cell values. What you can *not* do: Run calculations based on formats.
Having a list of numbers, you can apply a conditional format which applies a cell-style "Red" for all values >100. You get the count of all red cells by means of =COUNTIF(range;">100").
Or synchronized by a cell value:
Having a list of numbers, you can apply a conditional format which applies a cell-style "Red" for all values greater than the value in cell $A$1. You get the count of all red cells by means of =COUNTIF(range;">"&"$A$1).

Re: [Solved] Counting Types of Formatted Cells

PostPosted: Mon May 19, 2008 2:58 pm
by Milligan
cheers both... have never used macros, will have to work it all out.