CELL
Returns information about the formatting, location, or contents of a cell
Syntax
CELL(info_type, [reference])
Parameters
- info_type: Required. A text value specifying what type of cell information you want (e.g., "address", "col", "color", "contents", "filename", "format", "parentheses", "prefix", "protect", "row", "type", "width")
- reference: Optional. The cell that you want information about. If omitted, info is returned for the last cell that was changed
Example
=CELL("address", A1)