Hi ian,

You can do this by contitionally formatting your cell.
This can change the colour of your font when you type in the required value
into a cell.
--
Regards
Warren


"IanClegg" wrote:

Hi,
Can anyone help me with this one?
If a cell is updated can several other cells change colour?
eg. If a particular cell is changed, I want several other cells to be
highlighted by changing their colour

Is there a simple way of doing this?