I have a template that I've created, which V-lookups data from one spreadsheet into the template.
I want to set up some conditional formatting that will highlight if any of the formulas in any cell change from being a formula (and displaying the value that the formula looks up) to being a value.
For example, one of the cells is for a price, and is currently looked up from another spreadsheet. If the person completing the template overwrites that value in the price cell, I want it to turn Blue (let's say).
Can anyone suggest anything? Thanks :)