counting cells with colored backround.

[ezay671]

what formula can i use to return the total amount of cells in a column with colored backrounds?

[jeffreybrown]

Excel does not have a native function to do this, but you can use a UDF.

Try one of these:

http://www.excelforum.com/excel-form...red-cells.html

or

http://www.cpearson.com/excel/colors.aspx