Hi bhofsetz, Chip Pearson has this on his site, perhaps you can modify for
an average?

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

Hope this helps

Gilles

"bhofsetz" wrote in
message ...

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.


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=384693