hi
first question.
excel has no built in function to do this but it is possible with a UDF.
see this site for code to do this.
http://cpearson.com/excel/colors.htm
second question.
i don't think you can add text but you can count.
read up on the counta function in excel help.

regards
FSt1

"Shannan" wrote:

Is there a way to tell excel to add up all of the cells in a row that have
been filled in with a certain color?

Also, is there a way to tell excel to add up all of the cells in a column
that have writing (text not numbers) in them?