When you enter or edit a formula (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).), cell references and the borders around the corresponding cells are color-coded.
Color-coded cell references
If there are no squares at each corner of the color-coded border, then the reference is to a named (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) range.
Change references that are not a named range
Change references to a named range
- Do one of the following:
On the Insert menu, point to Name, and then click Apply.
In the Apply names box, click one or more names.
- Select the range of cells that contains formulas in which you want to replace references with names.
- Select a single cell to change the references to names in all formulas on the worksheet.