Microsoft Office Tutorials and References

In Depth Information

**REFER TO A CELL WHOSE ADDRESS VARIES, BASED ON A CALCULATION**

60
Returns
TRUE
if all the characters in the cell, or only the ﬁ rst character,

are formatted with a subscript font; otherwise, returns
FALSE
.

61
Returns the name of the PivotTable item for the active cell, as text.

62
Returns the name of the workbook and the current sheet, in the form

[book1]sheet1
.

63
Returns the ﬁ ll (background) color of the cell.

64
Returns the pattern (foreground) color of the cell.

65
Returns
TRUE
if the Add Indent alignment option is on (Far East versions

of Microsoft Excel only); otherwise, returns
FALSE
.

66
Returns the book name of the workbook containing the cell in the form

BOOK1.XLS
.

Summary:
You can use
GET.CELL
to return more information than is available

by using the
CELL
function. You can then use conditional formatting to highlight

every cell that does not contain a formula.

Source:
http://www.mrexcel.com/archive2/18800/21312.htm

Part

I

REFER TO A CELL WHOSE ADDRESS

VARIES, BASED ON A CALCULATION

Challenge:
You need to refer to a cell, but the cell address varies, based on a

calculation.

Solution:
The
INDIRECT
function takes an argument that looks like a cell

reference and returns the value in that reference.

In Figure 22, the formula in row 2 asks for the
INDIRECT
of the cell immediately

above the formula. So, in D2, the formula tells Excel to get the
INDIRECT
of

cell D1. Cell D1 has a valid cell address of C9. The formula returns the current

value from cell C9, which is 17.

Figure 22.
You can use the
INDIRECT
function to specify a cell

address, and Excel returns the value at that address.