Change cell color if formula is overwritten

[sscornav]

I have a basic spreadsheet that has a number of calculations. There are times when the calculations need to be overwritten with data input. I would like the cell to automatically change color if this occurs as a reminder that the cell was modified.

Prefer not to use VBA.

Only applies to certain columns on the spreadsheet.

I have a lot of flexibility on how to set this up, but I can't find a good solution for this.
Any help would be appreciated

Steve

 

[DRSteele]

Create a new Conditional Formatting rule for the cell. My cell is C5, where I have a formula.

The rule should be =NOT(ISFORMULA(C5)) , then choose a format. If the content of cell C5 is not a formula, the cell will be formatted with the desired format, which I chose to be a yellow fill.

 

[sscornav]

If forgot to mention that I am using Excel 2010. I don't think this function appears until 2013. Any other way around this problem?? It seemed so simple...

 

[DRSteele]

I think Conditional Formatting works in Excel2010, as indicated here:

https://support.office.com/en-us/ar...=ZXL160&HelpId=171614&ui=en-US&rs=en-US&ad=US

 

[Jaafar Tribak]

First create a name via the Name Manager and call it HasFormula that refers to=GET.CELL(48) .. Then select the cell and add the following conditionnal formatting formula : =Not(HasFormula) and choose the color you want.

 

[sscornav]

Thanks all. I would up putting a small piece of VBA code in. Although the get.cell seemed good, I couldn't get it to work one cell at a time. It kept highlighting all cells that had the formula, even though only one was overwritten.

Thanks!