Sam,
Thanks for your solution. I got it to work and with the modification
suggested by DILIPandey, it does what I wanted. I just have to be
careful that my user enters 5% and not =5%.
The track changes, while interesting and will be used in the future,
didn't fit because the formulas can be
Conditional Formatting Highlight of Changed Cells
I have a large spreadsheet where users occasionally will overwrite the
builtin formula with a value. I would like Conditional Formatting to
highlight these cells that were changed from a formula to a numeric
value. My first shot in Cell “A1” was a
Goto VBE, insert a new module in your workbook vba project, and add this
function
Function HASFORMULA(rngCell As Range) As Boolean
HASFORMULA = rngCell.HASFORMULA
End Function
In your conditional format rule, use =HASFORMULA(A1)
Regards,
Sam
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt
Hi Craig
you can use Track changes option from excel
http://office.microsoft.com/en-us/excel-help/about-tracking-changes-HP005230064.aspx
HTH
Mahesh
On Thu, Oct 6, 2011 at 1:24 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Goto VBE, insert a new module in your workbook vba project, and add
Dear Craig,
Please Try
Review-Track Change..
On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt craigbran...@gmail.com wrote:
Conditional Formatting Highlight of Changed Cells
I have a large spreadsheet where users occasionally will overwrite the
builtin formula with a value. I would like
Hi Craig,
Please find the solution attached as a sample. It has the same idea
as suggested by Sam. Thanks.
Feel free to get back in case of any queries.
Regards,
DILIPandey
On 10/6/11, Craig Brandt craigbran...@gmail.com wrote:
Conditional Formatting Highlight of Changed Cells
I have a