Conditional Formatting

[Phil Osman]

I have a range of cells that contain formulas, but I also need to give the
user the option to manually overwrite the result of any of these formulas.

Where the formula is overwritten I want the cell shading to turn yellow. I
can't see a way of doing using the Conditional Formatting tool.

Is there something else I could try ??

 

[David McRitchie]

Hi Phil,
Are you using Conditional Formatting to begin with ?
If so they answer is no, because C.F. overrides normal cell formatting..
Unless you are talking about a constant replacing what is normally a
formula in a column. You have to be able to identify what is different
by means of a C.F. formula which are the same as worksheet formulas.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

You can use a Change Event macro to indicate that a manual change
has been made, which could be manually turned off by anyone by
changing the formatting..
http://www.mvps.org/dmcritchie/excel/event.htm#change