< Back to screenshot

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

a 2
b 0.1
c 0.6

the routine would colour all direct dependents of parameter a in yellow, b in cyan 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.