|
Coloring Precedent and Source Cells
The Color Cells button is on by default.
Precedent references from the selected left-hand expression are colored in a light color with black text.
Source cells from the right-hand source-result box are colored in a dark color with white text.
You can change the color using Shift-Click on the Color button, and change the shading using Alt-Click on the color button.
In this example the reference K10:K17 in the left-hand box is reduced by Excel’s Implicit Intersection rules to K14 because the formula is in row 14 ($X$14 on the Formulas sheet).
The right-hand source result text is colored red to indicate implicit intersection.
.png)
IF statements in array expressions can return arrays of results for both the True result and the False result.
True result cells are colored Green and False result cells are colored purple.
.png)
In this example the IF expression is selected so both the True results and the False results are colored.
Rows 3 and 4 in the Price Column (F2:F5) are > 10 and so rows 3 and 4 are true but rows 2 and 5 are false.
The TRUE expression (D2:D5)*(G2:G5) gives D3:D4 and G3:G4 as source references so they are colored Green.
The FALSE expression I2:I5 has both a left-hand reference (I2:I5) and a right-hand source expression I2, I5, so the left-hand reference is colored light purple and the right-hand source reference is colored dark purple.
The text in the right-hand source result box is colored green to indicate that this is a Source reference.
|
