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
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
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.
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
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.