Determine the format of an Excel Cell

Today, I want to filter an excel file with strikethrough and find the method: ctrl + F3 to create a macro interface and enter a name, for example, CheckDeleteLine. The content is = GET. CELL (23, $ A1) $ A1 is replaced with the CELL to be checked. In a blank column, enter = CheckDeleteLine. If it is TRUE, there is a strikethrough. If it is FALSE, there is no strikethrough.

23 In GET. CELL can be found below:

1 = average
2 = left alignment
3 = in progress
4 = right alignment
5 = fill
6 = alignment at both ends
7 = cross-column center
9 indicates the type of the border line allocated to the left side of the cell
0 = No border
1 = Wire
2 = Medium Line
3 = dotted line
4 = dot line
5 = coarse line
6 = double line
7 = silk thread
10 indicates the type of the border line allocated to the right of the cell. For details about the returned values, see type_num 9.
11 indicates the type of the border line allocated to the top of the cell. For details about the returned values, see type_num 9.
12 indicates the type of the border line allocated to the bottom of the cell. For details about the returned values, see type_num 9.
13 "is a number between 0 and 8. When you select the [Cell] command under the [format] menu,
The [pattern] tab in the [Cell format] dialog box displays the selected cells. This number indicates the mode. If the mode is not selected, 0 is returned. [Note that there is a mistake here. It must be a number between 1 and 18. To [pattern ]"
14 if the cell is locked, TRUE is returned; otherwise, FALSE is returned.
15 if the formula in the cell is hidden, TRUE is returned; otherwise, FALSE is returned.
16 "a horizontal array containing two tops, including the width of the active cell and a logical value, which indicates whether the cell width has changed,
If it is TRUE, the standard width is changed. If it is FALSE, it is still the custom width. "
17. The Row Height of the cell represented by vertices
18 font name, text format
19 font size represented by vertices
20 if all characters in the cell or only the first letter is in black, TRUE is returned; otherwise, FALSE is returned.
21. If all characters in the cell or only the first character is italic. Returns TRUE; otherwise, returns FALSE.
22. If all or only the first character in the cell is the bottom line, FALSE is returned.
23 if all or only the first character in a cell is added with a strikethrough, TRUE is returned. Otherwise, FALSE is returned.
24 is a number ranging from 1 to 56, representing the font color of the first character in the cell. If the font color is automatically generated, 0 is returned.
25 "if all or only the first character in the cell is a hollow body, TRUE is returned; otherwise, FALSE is returned.
Microsoft Excel for Windows does not support the hollow font format. "
26 "TRUE is returned if all or only the first character in the cell is shaded. Otherwise, FALSE is returned.
Microsoft Excel for Windows does not support the shadow font format"
27 indicates whether the number in the cell can be manually split.
0 = No page splitting line
1 = line
2 = Column
3 = rows and columns
Level of 28 rows (hierarchical display)
Level of 29 columns (hierarchical display)
30. If the active cell is a summary row, TRUE is returned. Otherwise, FALSE is returned.
31. If the active cell in the column is the abstract column, TRUE is returned. Otherwise, FALSE is returned ..
32 [This note indicates an error. Click this link] "if a window contains only one table, the file name is the name of the workbook without the extension, and the name is the name of the workbook or worksheet containing cells,
Returns the name of the table file in the form of BOOK1.XLS; otherwise, returns the name of the table in the form of "[BOOK1] sheel.
"
33. If a cell is broken, TRUE is returned. Otherwise, FALSE is returned.
34 is a number between 1 and 16, representing the line color on the left side of the border. If the color is automatically generated, zero is returned.
35 is a number between 1 and 16, representing the line color on the right side of the border. If the color is automatically generated, zero is returned.
36 is a number between 1 and 16, representing the top border line color. If the color is automatically generated, zero is returned.
37 is a number between 1 and 16, representing the line color at the bottom of the border. If the color is automatically generated, zero is returned.
38 "is a number between 1 and 16, representing the foreground color. If the color is automatically generated, zero is returned.
[Including fill color and pattern color ]"
39 is a number between 1 and 16, representing the background color. If the color is automatically generated, zero is returned. [Shadow background ?]
40 cell style, text format.
41. The formula in the active cell is returned without translation (used for the macro table set by the chart ).
42 horizontal distance between the left boundary of the activity window and the left boundary of the cell, which is represented by a vertex. If the window is exclusive to the unit, it may be a negative value.
43 The vertical distance between the top boundary of the active window represented by a vertex and the top boundary of the cell. If the window is exclusive to the unit, it may be a negative value.
44 horizontal distance between the right boundary of the activity window and the right boundary of the cell, which is represented by a vertex. If the window is exclusive to the unit, it may be a negative value.
45 horizontal distance between the bottom boundary of the activity window and the bottom boundary of the cell, which is represented by a vertex. If the window is exclusive to the cell, it may be a negative value.
46. If a cell contains text comments, TRUE is returned. Otherwise, FALSE is returned.
47. If the cell contains sound comments, TRUE is returned. Otherwise, FALSE is returned.
48. If the cell contains a formula comment, TRUE is returned. Otherwise, FALSE is returned.
49 If a cell is part of an array, TRUE is returned; otherwise, FALSE is returned.
50 indicates the vertical alignment of cells.
1 = Top alignment
2 = in progress
3 = bottom alignment
4 = alignment at both ends
51 indicates the vertical direction of the cell.
0 = horizontal
1 = vertical
2 = up
3 = downward
52 cell prefixes (or text alignment). If a cell does not contain any content, it indicates null text ("").
53 The content of the currently displayed cell, in the text format, including the number or symbol added to the formatted cell.
54. The file name of the PivotTable view containing the active cells is returned.
55. Return the position of the cell in the PivotTable view.
56. In the PivotTable view, the field name that contains the reference of the active cell is returned.
57 if all characters in the cell, or only the first character is formatted as the upper font, TRUE is returned; otherwise, FALSE is returned.
58 "as the [font] label displayed in the [Cell format] dialog box to locate all characters in the cell or the body of the first character
Returns the font style, such as Bold Italic ". "
59. Return the number of distrip styles.
1 = no bottom line
2 = single bottom line
3 = double line
4 = (single accounting)
5 = (double accounting)
60 if all characters in the cell, or only the first character is formatted as the subscript font, TRUE is returned; otherwise, FALSE is returned.
61 is the file name of the PivotTable entry in the active cell returned as text.
62. Return the file name of the current table in the format of "[book1] sheet1. [Note: it should be an "activity worksheet "]
63 return the fill (background) color of the cell.
64. The color of the cell pattern (foreground) is returned.
65 "if the [Increase or decrease] Alignment option is on (only for Microsoft Excel Far East version, TRUE is returned;
Otherwise, FALSE is returned"
66. The name of the workbook containing the BOOK1.XLS format cells is returned.