I inherited a spreadsheet that uses whether or not a cell is boldfaced to
tell the reader something. I need to create mailing labels that only
reference the boldfaced cells. Is that possible? Or should I take the time
to redesign the project?

Use following UDF that will return TRUE if referenced cell is bold:

Function isBold(rCell As Range) As Boolean
isBold = rCell.Font.Bold
End Function

HTH
--
AP

"keybordrfm" a écrit dans le message
de news: ...
I inherited a spreadsheet that uses whether or not a cell is boldfaced to
tell the reader something. I need to create mailing labels that only
reference the boldfaced cells. Is that possible? Or should I take the
time
to redesign the project?

Nel post
*keybordrfm* ha scritto:

I inherited a spreadsheet that uses whether or not a cell is
boldfaced to tell the reader something. I need to create mailing
labels that only reference the boldfaced cells. Is that possible?
Or should I take the time to redesign the project?

I think the second should be better...

Till Excel 2003 the function can manage cells' values, not formatting.

Maybe you can succeed with some VBA code, but I can't help that way...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy