Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-07 Thread Craig Brandt 
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  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  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

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-06 Thread Dilip Pandey 
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  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
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
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


CF-HasFormula chk.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-06 Thread NOORAIN ANSARI 
Dear Craig,

Please Try

Review-Track Change..

On Thu, Oct 6, 2011 at 2:29 AM, Craig Brandt  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
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
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

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-06 Thread Mahesh parab 
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 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 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

Re: $$Excel-Macros$$ Conditional Formatting Highlight of Changed Cells

2011-10-06 Thread Sam Mathai Chacko 
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  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