The CELL function returns information about a cell such as formatting, location, and contents.
The formula syntax requires the info_type argument. This argument is a text value that tells the function which type of information you want to return.
There is also the reference argument. It is an optional argument.
This argument is the cell that you want information about. It can also be a range of cells. In that case, the function will return information about the cell in the upper left corner.
If you omit the reference argument, the information for the last changed cell is returned.
There are 12 available information types you can use as the info_type argument.
The “format” info_type returns any of several potential results. These are all the possible CELL format codes:
Let’s look at some of these info types used in a few different. We start with nine rows of data of different types.