The first differentiation is if you want to select cells with strikethrough formatting or if you want to rather insert a function that checks if another cell is crossed out. Insert function (“UDF”) and return TRUE or FALSEĮntire cell or only parts of the cell have strikethrough formatting Select all cells with strikethrough formatting The options to identify strikethrough Excel cells can be separated into two dimensions:

So, in this article you will find multiple VBA code snippets that you have to copy and paste into a VBA module. There is only one workaround using the Find window (see option 1 below) but for all other options it means, we have to switch to VBA. The bad news first: Excel does not have a comfortable built-in functionality to find and select all strikethrough cells in Excel. Instead of using cell formatting, the proper way would be to insert another column (or row) and write down the comments there (also the comments and notes functions have their disadvantages). I have already described in this article how to evaluate the number format. Formatting is very difficult to evaluate. But also, strikethrough is unfortunately used quite often. Most common is probably to use color codes or currency information in cell formatting. Never transport information with formatting in Excel! Professor Excel One of my basic rules (before we start solving the problem): Expert Tip: Use Professor Excel Tools to do all this very comfortably.Option 4: Return TRUE or FALSE if only parts of cell have strikethrough formatting.

Option 3: Return TRUE or FALSE if entire cell has strikethrough.

Option 2: Select all cells with only partial strikethrough.

Use a VBA macro to select all strikethrough cells.

Use the Find window to select all strikethrough cells.

Option 1: Select all cells with strikethrough formatting on the entire cell.

How to do strikethrough in excel 2007