The CELL function in Excel is very powerful and relatively unknown to many. Use the Excel CELL function to return information about a cell. This can include the cell’s number format, row number or whether it is locked or protected.
There are times when this kind of functionality becomes extremely useful. Especially while Excel does not provide many other means of finding the number format of a cell, or whether it has been locked.
[Read more…] about Excel CELL Function – Return Cell Information