I want to only at cells that are in bold to a total in Excel

[Guest]

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

 

[JE McGimpsey]

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.

 

[Earl Kiosterud]

Conrad,

Here's a suggestion. Before you get too committed to using formatting
(bold) to indicate things, take a look at
http://www.smokeylake.com/excel/excel_truths.htm. Read "Color as data."