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.com>wrote: > 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 <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 Conditional Formatting to >> highlight these cells that were changed from a formula to a numeric >> value. My first shot in Cell “A1” was a conditional formula of >> “ISNUMERIC(A1)” just to see if it could detect a number as opposed to >> a formula. Did nothing and I cannot find an alternate solution. I saw >> suggestions of using a user defined Function but very limited exposure >> to that and didn’t have any success in making it work. >> >> Thanks for any help, >> Craig >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Sam Mathai Chacko > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
