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

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

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

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."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Conrad" wrote in message
...
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