[Solved] Counting Types of Formatted Cells

Discuss the spreadsheet application

[Solved] Counting Types of Formatted Cells

Postby Milligan » Sun May 18, 2008 10:18 pm

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!
Last edited by Milligan on Mon May 19, 2008 2:42 pm, edited 1 time in total.
Milligan
 
Posts: 2
Joined: Sun May 18, 2008 10:05 pm

Re: Counting Types of Formatted Cells

Postby Hagar Delest » Sun May 18, 2008 11:05 pm

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.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 29006
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Counting Types of Formatted Cells

Postby Villeroy » Sun May 18, 2008 11:17 pm

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).
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Villeroy
Volunteer
 
Posts: 28679
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: [Solved] Counting Types of Formatted Cells

Postby Milligan » Mon May 19, 2008 2:58 pm

cheers both... have never used macros, will have to work it all out.
Milligan
 
Posts: 2
Joined: Sun May 18, 2008 10:05 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests