How to test a cell for the strikethrough effect?

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

Guest

What formula, if any, would return, say, "true" or "false", for the presence
of the strikethrough effect on text in a given cell?
 
No formula can return formats.

Try this macro.

Make sure you have an empty column to the right of the selected cells.

Sub Strike_Through()
For Each cell In Selection
If cell.Font.Strikethrough = True Then
cell.Offset(0, 1).Value = "TRUE"
Else: cell.Offset(0, 1).Value = "FALSE"
End If
Next cell
End Sub


Gord Dibben MS Excel MVP
 
No formula can return formats.

It can be done with a named formula that uses GET.CELL but a UDF or macro is
easier to work with.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I detect strikethrough formatting in a cell? 2
copying data from one cell to another in a workbook in Excel 2003 7
Sorting a spreadsheet by strikethrough? 1
IF Strikethrough 8
Find partial cell format 7
Conditional Formating Based on Formats Instead of Values 1
How to remove red strikethrough generated as an error? 1
Any way to count cells contining one, or more STRIKETHROUGHS? 8

Back
Top