Results 1 to 3 of 3

Thread: Color Functions In Excel

  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10

    Lightbulb 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
    Attached Files Attached Files

  2. #2

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Unfortunately not
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Learning To Write Excel Formulas And Functions
    By venkat1926 in forum Excel Help
    Replies: 0
    Last Post: 05-19-2013, 09:30 AM
  2. Declaring API Functions In 64 Bit
    By marreco in forum Excel Help
    Replies: 2
    Last Post: 02-11-2013, 03:18 AM
  3. Combining Functions To Create Array Formula
    By Ryan_Bernal in forum Excel Help
    Replies: 3
    Last Post: 01-07-2013, 12:38 PM
  4. Excel Macro Functions (GET.DOCUMENT)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 2
    Last Post: 06-29-2011, 08:10 PM
  5. Excel Macro Functions (GET.CELL)
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 05-17-2011, 08:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •