View Single Post
  #1   Report Post  
bhofsetz
 
Posts: n/a
Default Conditional Calculation


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