PopTools logo

Colour dependent cells

This routine sets the font and interior colour of the direct dependents of a range of cells in the same colour as each cell in the selected range. It can be used to quickly show the dependence of cells on one or more parameters. For example if you have a column of parameters that looks like this


the routine would colour all direct dependents of parameter a in yellow, b in blue and c in green.

Note: If the dependent cells are affected by more than one cell in the parameter range the colours of the dependent cells will be determined by the last cell in the parameter range.

Footer image - matrix analysis