-
1 Attachment(s)
Color Functions In Excel
Hi,
Here are some color functions.
Syntax will be same for all functions.:
Code:
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 :)
-
-
