Microsoft Excel Cell Color Add In

MS Excel Add-In function to count the number of cells in a selected region that has a certain background cell color.

Add-In Installation, Setup, and Use

1. Extract ColorFunction.xla (for Office 97-2004) and ColorFunction.xlam (Office 2007-2010) files

2. Open up an Excel Worksheet

3. Go to Tools and select Add-Ins…

4. Click Select… and browse to select the file for the appropriate version of MS Excel

5. Click OK to exit

6. To use the function, type =ColorFunction(C12,C11:C24,FALSE) where C12 is the cell that has the same color that you want to count cells, C11:C24 is the range of cells over which you want to count, and to output the sum/count of the cell values highlighted in the desired color (TRUE/FALSE)

7. This should install the Add-In for the Excel installation and should need to be repeated