Take a look he

http://cpearson.com/excel/colors.htm


In article .com,
"Paulus" wrote:

I have 12 columns with my monthly expenses.
If the expense is paid, I change the color to e.g. Green.
I want row 2 on top of EACH month-column to show the sum of non-green
cells in that column.