Cell attributes – Excel kitchenette

Each cell in the worksheet can be blank or have some content (text, number). It can also have its own formatting elements. The CELL function allows you to read the attributes of a cell, however it is not nearly as powerful as the old GET.CELL macro function. In the following text, you will learn how to read cell attributes.

The cell attribute is read using the CELL function, whose syntax is:

CELL (<code>, <address>)

You can see the meaning of the codes in the following table:

CODE	DESCRIPTION
address	Default cell address (text).
col	Column number.
row	Row number.
color	Returns a score of 1 if the first reference cell is formatted using the color for negative number values, or 0 if it is not.
contents	The value of the cell.
filename	The path and file name.
format	A tag that represents the format of a number record.
parentheses	If negative numbers are shown in parentheses, it returns value 1, or returns 0 if they are not.
prefix	Text that corresponds to the cell tag prefix.
protect	If the cell is Locked it returns 1 and if it is not (Unlocked) returns 0.
type	Index indicating data type: B for empty cell, L for label, V for value.
width	The width of the cell.

That is, an example of using this feature can be seen in the picture:

The GET.CELL macro function cannot be directly applied in a formula. To use it, you need to get into Name Manager (CTRL + F3), and create a new name, where we will enter the GET.CELL function as a reference, which has the same syntax as the CELL function It has many more parameters, is described in detail on Mr.Excel’s website, and you can access the text at the following link.