Is there a function that tells if text in cell is boldfaced?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
Click to expand...

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
 
Back
Top