You'll need to use a UDF. One way:

http://www.mcgimpsey.com/excel/udfs/sumbold.html

Note that there's no event in XL that causes a recalculation when a cell
format changes, so you'll have to specifically recalculate after
setting/clearing the bold format to be sure that the result of the UDF
is up-to-date.


In article ,
Conrad wrote:

My colleague has gone through a table and highlighted certain cells in bold.
I would like to write a formula that only adds the totals that are in bold.
It seems to me that I need the reverse of the conditional formatting option,
is this possible? I am using Office 2003.

Thanks