Forum Discussion
Counting function depending on color
How to count cells according to the color of the numbers in them. Specifically those that contain black numbers. Possibly only from colorless cells.
- Not by the color of the cells but by the color of the numbers. 😞
Use option 24 for the get.cell method in the youtube video. However, note that changing the font color will most likely not trigger any excel events that are practical to use to trigger the worksheet to recalculate/update, so your total may not update right away (but you can force the worksheet to calculate).
https://www.mrexcel.com/board/threads/info-only-get-cell-arguments.20611/
If possible, I would suggest making some rules for how the cell fonts should be colored and using those in conditional formats. Then, use the same logic/rules in a countif(s) formula.
Here is a small example with red numbers
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- When I change the color of the number it no longer makes the addition.
And anyway, I need to count them, not gather them.
