View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default Can I total only numbers with a specific font color?

See

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

In article ,
BLillie11 wrote:

I have a column of numbers with different color fonts. Is there a way to
create a formula to total only those numbers with a specific font color? For
example, only the cells whose font has been formatted red?