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?

Let us say that you want cell A2 to turn green if cell M2 has a
number entered

Put the cursor in A2, and use conditional formatting. Instead of
"Cell value is" select "Formula is" and for a condition enter
"=M20" (without the quote marks) Then choose the format you
want to apply.

Use the format painter to copy down the A column.

If you want to use the same format for other columns, then make
the formula "=$M20" and you can copy the format to adjacent
columns.

Beware when copying the format that it will overwrite any
existing formatting.

Chris
--
Chris J Dixon Nottingham UK


Have dancing shoes, will ceilidh.