Color Functions In Excel

[Admin]

Hi,

Here are some color functions.

Syntax will be same for all functions.:

Function FunctionName(ByRef InputRange As Range, ByRef CritColor, Optional ByVal FontItIs As Boolean = False) As Double

End Function

Replace the FunctionName with any of the following.

CSUM : SUM by either Cell Color or Font Color
CAVERAGE : AVERAGE by either Cell Color or Font Color
CMAX : MAX by either Cell Color or Font Color
CMIN : MIN by either Cell Color or Font Color
CCOUNT : COUNT by either Cell Color or Font Color
CCOUNTA : COUNTA by either Cell Color or Font Color

Appreciate feedbacks

[jamilm]

Hi Admin,

this is a very good code. but one issue that it does re calculates and i have to press each time recalculation. is there anyway this could be improved?

thanks.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=kfQC-sQxMcw&lc=UgyCxQWypNIhG2nUn794AaABAg.9q1p6q7ah839t UQl_92mvg
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg. 9isY3Ezhx4j9itQLuif26T
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg. 9irSL7x4Moh9itTRqL7dQh
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg. 9iraombnLDb9itV80HDpXc
https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg. 9is0FSoF2Wi9itWKEvGSSq
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[Admin]

Unfortunately not