There are some hidden functions in Excel that enable you to implement functions that are not implemented by existing functions. One of the most important functions is Get.cell. Get.cell translation is the meaning of "get cell", the function is to return the format information in the cell.
function definition: Get.cell (type number, cell (or range))
The type number, which is the type number of the information you want to get, is tested with a range of 1-66, which means that the function can return 66 kinds of information in a cell.
The following is the type and the meaning of the representative
1--the absolute address of the reference cell
2--the column number of the reference cell
3--the column number of the reference cell
4--similar to TYPE function
5--the contents of the reference address
6--text display reference address formula
7--the format of reference addresses, text display
8--text display reference address format
9--back to store extra box left style, digital display
10--back to store extra box to the right style, digital display
11--back to store the extra box on the side of the style, digital display
12--back to store the extra box-side style, digital display
13--back internal pattern, digital display
14--If the cell is set locked returns TRUE
15--returns True if the formula is in a hidden state
16--Back to cell width
17--returns the height of the cell in dots
18--Font Name
19--returns the font size in dots per unit
20--returns True if all or the first character in the cell is bold
21--returns True if all or the first character in the cell is italic
22--returns True if all or the first character of a cell is a single line
23--If you add a horizontal line to the middle of all or the first character fonts in the cell, returns True
24--returns the first character color number of the cell, 1 to 56. If set to Automatic, send back 0
25--ms Excel does not support outline formatting
26--ms Excel does not support shadow formatting
27--Digital display of manually inserted page-line settings