SA Footy

Can any of the Excel gurus out there help me with a function? If you have columns on a worksheet where some font is black and other has been changed to red, can a function be written to only add all the red-font values? Much obliged.

Hey FH,

Here is something that may talk you through how you can do it.

http://www.fontstuff.com/casebook/casebook01.htm

Thanks Ron, much appreciated. Looks like I'll be able to make something of it.

Possibly something in this utlitiy:

www.asap-utilities.com

Otherwise go see www.mrexcel.com and check out his forums.