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.
12 Replies
- 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.
