GOOGLETRANSLATE TRANSLITUA TRANSLITRU CLEANTEXT CLEANDIGITS GETSUBSTR GETNUMBER GETDATE GETURL CONCATIF SUMBYCELLCOLOR COUNTBYCELLCOLOR SUMBYFONTCOLOR COUNTBYFONTCOLOR GETCOMMENT GETSEX GETWORD WORKBOOK SHEETNAME TABLETOARRAY TABLETODICT TABLETOCSV TABLETOSQL TABLETOHTML TABLETOJSON TABLETOXML WORKHOURS ISOCOUNTRY

- UPPER REGISTER
- lower case
- With a capital letter
- Words with capital letters
- The first character is capitalized
- Other variants of registers
- Delete all letters
- Delete all numbers
- Remove trailing spaces
- Remove extra spaces
- Remove leading characters
- Remove trailing characters
- Delete text after a certain number of characters
- Get the word by the specified separators
- Mark the Latin letters
- Mark Cyrillic letters
- Google Translate...

- Apply additional calculations to selected cells
- Change the formulas to their calculated values
- Converting unrecognized numbers (text?) to numbers
- Change value to text (adding ' in front)
- Fill the cells with their formatted value
- Change negative numbers to positive and vice versa
- Move the minus sign from the end to the beginning (for example, 47- to -47)
- Use a substantial number of commas
- Writing a number or sum in words
- Date conversion/recognition

TOP
# CountByFontColor function for LibreOffice Calc

## COUNTBYFONTCOLOR() Description

## Main Features Functions COUNTBYFONTCOLOR

### Syntax:

### Parameters:

## Example Usage

## Do you recognize any of these situations?

## Notes on the calculation

## Download the extension

Many people use colors to indicate cells. Working with cell colors can make it easier to understand the data in the LO Calc workbook.

Unfortunately, LO Calc has no built-in functions for using cell colors as conditions in formulas. Building formulas that only count or sum cells of certain colors can get really cumbersome. This often results in complex formulas that are prone to error when making changes.

The COUNTBYFONTCOLOR() function counts the number of cells that have a certain font color.

```
=COUNTBYFONTCOLOR(Range; SampleCell)
```

- Range: A range with cells to count.
- SampleCell: A cell that contains a color sample.

The COUNTBYFONTCOLOR() function is easy to use. You just need to select the desired range of cells and specify the cell that contains the desired color, and LibreOffice Calc will automatically count the number of cells with the same text color:

=COUNTBYFONTCOLOR(A1:D10; F3)

We will have the following result:

This example uses the following values:

- Range: A1:D10 - Range with cells.
- SampleCell: F3 - A cell that contains the required font color (red).

- Not sure if YLC has this feature, but it would be useful to be able to count the colored cells in a range. Let's say I have 17 cells with red font color in the range B1:B500. I need a formula that counts those 5 cells with red text.
- Can I use color as a COUNTIF condition? I have a column in which I need to count the number of cells with red text.
- I noticed that in recent versions of LO Calc can sort by cell color and font. What about the LO Calc function? Can formulas also work with cell and font colors?
- How to count or sum cells by their fill or background color? There doesn't seem to be a formula in LO Calc that would count or sum a range of cells based on a specified background color.

Because LO Calc only recalculates the formula when the value in the (referenced) cell changes, not when the colors change, some worksheet formulas don't always trigger to update. In this case, you can use F9 or Ctrl+Alt+F9 to update the formulas in YLC Utilities.

You can use the COUNTBYFONTCOLOR() function by installing a free extension YouLibreCalc.oxt or its full-featured version YLC_Utilities.oxt .

After that, this function will be available in all files that will be opened in LibreOffice Calc.

- 1. What is VBA, basic concepts.
- 2. Debugger (Debugger)
- 3. Working with sheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties (Properties)
- 6.1. Data types (Variables)
- 6.2. Data Types (Continued)
- 7.1. Conditions (Conditions)
- 7.2. Terms (Continued)
- 8.1. Loops (Loops)
- 8.2. Cycles (Continued)
- 9. Procedures and functions
- 10. Dialog windows
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls (Controls)
- 12.3. Control elements (Continued)
- 12.4. Control elements (Exercises)
- 13.1. Arrays (Arrays)
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function

- 1. SQL language, basic concepts.
- 2. Data selection (SELECT)
- 3. Data sorting (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Use of metacharacters (LIKE)
- 6. Calculation (calculation) fields
- 7. Data processing functions
- 8. Data grouping (GROUP BY)
- 9. Sub-requests
- 10. Combination of tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined requests (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)

- Import of currency rates from the NBU website
- Sum written in English
- Unpivottables (Unpivot)
- Function
Google Translate - Camel Case Function
- Snake Case Function
- Kebab Case Function
- Break Case Function
- Sentence Case Function
- Title Case Function
Fuzzy Lookup Function- Function GETSUBSTR
- Free extension "YouLibreCalc"
- Professional Extension "YLC Utilities"