SheetFX
≡
<< Go back to all functions

CELL

The CELL function in Google Sheets is a powerful tool to return information about the specified cell. Whether you're working with data validation, conditional formatting, or data analysis, the CELL function can provide valuable insights. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: CELL(info_type, reference)

Parameters:

  • info_type: The type of information to be returned. This can be "address", "col", "color", "contents", "filename", "format", "note", "protect", "row", "type", or "width".
  • reference: The reference to the cell or range of cells for which you want to retrieve information.

Step-by-Step Tutorial

  1. Using CELL to get the address of a cell:

    • Example: =CELL("address", A1)
    • Result: $A$1

  2. Using CELL to get the column of a cell:

    • Example: =CELL("col", B3)
    • Result: 2

  3. Using CELL to get the color of a cell:

    • Example: =CELL("color", C4)
    • Result: #FF0000 (red)

Use Cases and Scenarios

  1. Data Validation: Retrieve the address of the cell where the data validation is applied.
  2. Conditional Formatting: Get the color of a cell for conditional formatting purposes.
  3. Data Analysis: Obtain the contents, format, or note of a specific cell for further analysis.

Related Functions

  • INDIRECT: Returns a cell reference specified by a text string.
  • INFO: Returns information about the current operating environment.

Related Articles