Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Warning when formula in a cell is changed

Perhaps place the same formula on a locked sheet and then Conditionally
format the cell in question to be red if the cells values are not the same?

Lciotinga wrote:

I am building a template and I cannot lock all the cells with formulas from
users. I do want to see when a formula in a specific cell has been changed
from the original. Is there a way to do this with other formulas?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format changed when the details in cell changed angel Excel Worksheet Functions 9 July 15th 08 12:36 AM
update formula in column when another cell formula is changed Susanelm Excel Worksheet Functions 1 June 9th 08 05:06 PM
With a formula in a cell, what is the warning symbol for? brobcpa Excel Discussion (Misc queries) 1 March 28th 07 03:24 PM
Help with a blank cell warning Maxemily Excel Worksheet Functions 1 March 30th 06 03:56 PM
How do I set a formula that indicates a if a cell value changed? Zachie Excel Worksheet Functions 3 March 9th 05 10:03 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"