Hi

I was wondering if anyone knew if it was possible to get Exel to
automatically flag cells that use a specific cell in their formula, but only
when the value of the specific cell has been changed.

I have a speadsheet which is updated regularly, however, the same cells do
not always need to be updated. The cells that are updated initially are in
the first half of the spreadsheet. These cells are then used in the formulas
of cells in the second half of the spreadsheet. However, changes in value
also need to be made to the cells in the second half, but only if changes in
the first half have occurred. I was hoping that instead of having to go
through and marking each cell that needs to be updated one at a time, exel
would be able to flag up the cells which contain the initial cells in the
formula which were already updated and then it would be just a case of
plugging in values. It would save so much time, not to mention my eyesight.

Hope this makes sense.

Any help would be very much appreciated.

Thanks

Hoc