Activate a function

[jevicha2]

I have finally got a function that counts the number of cells with a "red" font. How do you activate it to update the number when another cell has been enter with a red font? The name is "CountFontColor" and a macro button won't pick it so. Maybe a button click?

Thanks

Jerry

[AliGW]

So is this a VBA query?

[jevicha2]

Sorry, was intended to be in Formulas and Functions. Would you be so kind to place it where it goes?

Jerry

[AliGW]

I don't think so. If you are wanting to use a command button for what looks like a UDF (user defined function), then it's a VBA query. I am moving your thread there now.

[MrShorty]

Assuming this is a VBA procedure that you are calling from a spreadsheet cell like =CountFontColor(range), then I would suggest you make the function volatile by adding Application.Volatile to the function https://docs.microsoft.com/en-us/off...ation.Volatile This will make the function volatile that it calculates with every calculate event.

[rorya]

You should note however that changing the formatting of a cell will not trigger a recalculation on its own.

[jevicha2]

McShorty, thanks for that info but I have discovered another problem. Since the red fonts are not manually entered, but thru CF and it looks like CF owns the rules when it comes to formatting and the function won't count those cells that were CF'd. Attached is an example with conditional formatting. Take a look and see if CF can be included.

[rorya]

You'd be better off using COUNTIFS and replicating whatever criteria were used to colour the cells in the first place.