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