The Excel CELL function returns information about a given cell. This can be information in relation to the contents, formatting or location of the cell.
The syntax of the function is:
where the arguments are as follows:
info_type    Specifies the type of information to be returned. This can be either:  
 
reference    The cell that the information is to be returned for. Note:

The following spreadsheets shows examples, of the Excel Cell function being used to return different properties of the cell A1. It should be noted that, in the example spreadsheet below, the cell A1 is formatted with the Custom Format #,##0; [Red]  #,##0.
Formulas:  Results: 
If the formatting of cell A1 in the above spreadsheet is changed, the formulas in cells B1B12 will not immediately recalculate. You can force them to recalculate by pressing the F9 key.
Note that, in cell B6 of the above example spreadsheet, the "format" type is returned as ",0". This is comprised of two parts: the ",0" part, which represents the #,##0 number format, and the "" part, which indicates that the cell is formatted in color for negative values.
Further information and examples of the Excel Cell Function can be found on the Microsoft Office website.
If you get an error returned from the Excel Cell Function, this is likely to be the Excel #VALUE! error:
#VALUE!    Occurs if the supplied info_type argument is not one of the recognised types (see the table at the top of this page). 