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 changed to other formulas and this is OK. I wanted to highlight only those cells take had a hard coded numbers in them.
Thank you all for your asistance, Craig On Oct 6, 2:54 am, 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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
