Formula deleted

[manjuru]

Hi Guys,

Thank you so much for your support till now.

I have a consolidated sheet where i had put some Vlookup,if, formulas for some cells in my sheet many of my collegues will be updating data in to that sheet some time by mistakely some formula cells deleted and it will difficult to find the cell where the formula is deleted.

Is there any way if formula is deleted in some cell then the color of the cell the should change to Red.

other way we can protect cell but thing is I have too many formula in different cells..

Can any one help me.....

Regards
Manju

 

[Andrew Poulsom]

Why can't you just unlock the cells that you want the user to be able to change and protect the worksheet?

 

[p45cal]

other way we can protect cell but thing is I have too many formula in different cells..

No you don't!
First select the whole range that's being used or will be used on that sheet, then go into Format cells… and uncheck the box that's labelled "Locked" on the Protection tab.
Now select any single cell, press function key F5, click the Special… button and choose Formulas and ensure (all 4 sub-checkboxes are also checked), then OK. Now with these cells selected, go back into Format cells… and check the Locked box, click OK. Finally, don't forget to protect the sheet.

 

[SuperFerret]

Maybe conditional formatting?

Cell Value - Not Equal To - your formula - cell fill RED

But if you have a LOT of different formulas there may be a more guru-like solution!

EDIT: Told ya