Thought I could use conditional formatting, but...

[Peacedout]

If a user of my spreadsheet deletes a formula from a cell, I'd like him to be alerted to that fact so he can restore it. I thought I would be able to use conditional formatting (e.g. the cell would turn red if the formula was accidentally deleted), but nothing seems right for that purpose.

 

[Chihiro]

Why not just protect the sheet so user can't accidentally delete formula?

 

[Peacedout]

I'm pretty sure (if memory serves me correctly) that I have some things in the sheet that don't work if the sheet is protected.

 

[Chihiro]

Ok, what version of Excel do you have? If 2013 or later...

You could use =ISFORMULA(Cell Reference)

 

[Peacedout]

Thanks for your replies, btw... 2007

 

[Chihiro]

Ok... then use Get.Cell()

Note that this must be set up as named range formula. You can't use it directly.

First select top left cell of range you are checking.

Then open name manager and enter following:
=Get.Cell(6,relative cell reference)

Then select entire range that CF should apply to and enter following.
=ISERROR(Find("=",NamedRange))

See attached sample.

NOTE: Get.Cell() is legacy xl4Macro function. So you will need to save file as xlsm or xlsb.

See link for more detail on Get.Cell()
https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html

Edit: CF formula may be better as LEFT(NamedRange,1)<>"=".

 

[Peacedout]

Thank you, again