| View previous topic :: View next topic |
| Author |
Message |
nanzan
Newbie
Joined: 11 Apr 2010
Posts: 1
|
 Posted: Sun Apr 11, 2010 11:39 am Post subject: Emulating the Excel CountColor function |
 |
|
I have an Excel spreadsheet for a sports team, with its W-L-T records over a decade. The background color is green for a Win, yellow for a Tie(Draw) and red for a Loss. In Excel, I use the CountColor function to keep a running total of each. Is there a similar function in OOCalc that will accomplish the task?
Thank you |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Apr 11, 2010 12:09 pm Post subject: |
|
|
There is no such function in Excel. You installed some add-on or VBA function to get this function.
Hiding values in attributes is very bad spreadsheet design.
A set of functions to fix such broken spreadsheets:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=2762
Get the color codes, convert formulas to values and apply conditional formatting.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
|
