Only through the use of a VBA user defined function.

Excel can't do this on its own.

See Chip Pearson's site for code on summing, counting etc.

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


Gord Dibben Excel MVP


On Tue, 5 Jul 2005 16:49:43 -0500, bhofsetz
wrote:


Is there a way to have a worksheet function perform a calculation based
on the font color or interior color of a cell?

Basically I'd like to have the function calculate the average of a
range of cells and then be able to change the font color of certian
entries in the range so that those would be excluded from the average
calculation.

Thanks for any suggestions.