Change font color if someone changes original file

[HUGOOLIVEIRA28]

Hello once again.

Is there a way to create a condition so that Is someone makes any changes to my original file, the font color changes to red e.g., and maybe be blocked that way.

Thank you for all the help.

Moderator Comment: Thread Moved.

[Gregor y]

my simple hack to do this was to:

1. copy the tab you want to format
2. setup a conditional formatting to color when the cell on this tab doesn't match the copy
3. hide the copied tab

[BMV]

makes any changes to my original file,

It depends on what change must be detect. It is not hard to control change constant and formulas but not rest. Simple comparing with copy of sheet can be wring because the formula could be changed but current result is the same or formula have was replaced by value.

[protonLeah]

Why not use the built-in TRACK CHANGES option under the Review menu?

[HUGOOLIVEIRA28]

Hello protonLeah,

Didn't knew that option, going to explore it. Nice hint, Thank you.