Conditional Formatting - applying when a formula is overwritten?
Posted by Todd K on February 08, 2002 2:35 PM
I want to know if it is possible to apply a conditional format (a coloured cell) when a user overwrites a cell's inherent formula. I have created a timeline worksheet - and want to know when a user has placed their own date in a cell (and not allowed the cell's formula to do the calculation).
Thanks for any help.
Posted by Derek on February 09, 2002 7:34 AM
The method I use is to prevent overwriting by using Data Validation. I restrict entries to exactly 256 character text length.
This doesn't prevent deletion, so I use conditional formatting to turn the cell black if its value is ""
Otherwise you can protect the worksheet.
Hope this helps
Derek
Posted by Todd K on February 10, 2002 2:05 PM
I am not sure this gets to what I am looking for...I have no problem with the user adding a value of their choice to the cell, but my interest is to make sure to all who use the workbook that they know that a particular cell has been "changed" by someone - through a format change to the cell as the preferred option. I did not see a cell format change option in the Data Validation section?
