|Yes, the colorfunction is from Dave Hawley's site, OzGrid.com.|
I haven't exactly figured out how I am going to use the colorfunction. Right not it is in the dummy column (ie column 3, 6, 9 etc.). It is basically a nested if statement that determines if the cell is a certain color.
[Column A is category, Column B is information about the category with a fill color and Column C is the dummy column with the nested if statement.] It reads that if cell B4 is the same color as A33 then it counts it (false means count, true mean sum). If it counts it then 1=1 and the number 4 is entered. Same thing for the next 3 colors. And if there is no fill then it enters a 0.
So I have to use it in this manner to have it recognize the fill color because yes the colorfunction counts and sums cells based on the fill color. The dummy column formula works fine. It was the only way I knew to try and get the categories in column A, D, G etc. to rollup onto another tab without an even crazier nest if statement. [It was going to be part of the process that I have yet to figure out.]
All I want is the categories (column A) in a new column based on the fill color in column B on the same row. And I don't want spaces in between where there were other colors or blanks.
Thanks for all the help.