In the following lesson I go through the Experience Level 1 Information Functions. These functions are used to obtain information about formatting & referencing about specific cell or range references. In this lesson I review the following functions:
ISBLANK - ISERROR - ISTEXT - ISNONTEXT - ISNUMBER
as well as the following info_types of the CELL() function:
"address" - "row" - "col" - "contents" - "width" - "filename"
"color" - "prefix" - "protect" - "type" - "format"
The CELL("format") info_type has many code results, so I've summarized them here: i.imgur.com/QJKY4.png
Make sure to download the latest Master Workbook to follow along with the video lesson.
Loading more stuff…
Hmm…it looks like things are taking a while to load. Try again?