$$Excel-Macros$$ Re: Error Checking option.
Hi Abdul, Select the cell and try the following code. Sub check() If ActiveCell.HasFormula Then MsgBox ("cell contains formula") Else MsgBox ("cell does not have formula") End If End Sub Thanks & Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Fri, May 22, 2009 at 8:08 PM, Abdul Hakim wrote: > > Dear All, > > I want to check the cell value via conditional formatting that whether > the value is manual entered or formula. > > can any body assist me to solving this problem. > > Regards, > Abdul Hakim... > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
Thanks a lot. it solve my problm. On May 26, 7:39 am, ddadmin2009 wrote: > In excel 2007, go to Formulas -> Define Name...and for conditional > formatting, Home -> Conditional Formatting -> New Rule -> Click on "Use a > formula to determine which cells to format". > > On Mon, May 25, 2009 at 6:20 AM, Abdul Hakim wrote: > > > > > > > Hi All > > I am quite confused for excel 2007. > > please let us know with full details As i could not found name-> > > define in excel 2007. > > Please assist me . > > > Regards, > > Abdul > > > On May 25, 8:18 am, ddadmin2009 wrote: > > > Hi, There is a simple solution without creation of a UDF for this. This > > is > > > old traditional way of doing in excel. Check the article below.. > >http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas... > > > Hope this helps. > > > > On Fri, May 22, 2009 at 5:20 PM, Aindril De wrote: > > > > Dear Abdul, > > > > > Create the following UDF in a module: > > > > > Function IsFormula(cell_ref As Range) > > > > IsFormula = cell_ref.HasFormula > > > > End Function > > > > > Now in your conditional formatting, use the formula is option and refer > > to > > > > this function. and put the formatting you want. > > > > > Only drawback in this is it will consider one cell at a time with this > > > > formula. > > > > > Regards, > > > > Andy > > > > > On Fri, May 22, 2009 at 9:38 PM, Abdul Hakim > >wrote: > > > > >> Dear All, > > > > >> I want to check the cell value via conditional formatting that whether > > > >> the value is manual entered or formula. > > > > >> can any body assist me to solving this problem. > > > > >> Regards, > > > >> Abdul Hakim... > > > > --http://funwithexcel.blogspot.com/ > > --http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
In excel 2007, go to Formulas -> Define Name...and for conditional formatting, Home -> Conditional Formatting -> New Rule -> Click on "Use a formula to determine which cells to format". On Mon, May 25, 2009 at 6:20 AM, Abdul Hakim wrote: > > Hi All > I am quite confused for excel 2007. > please let us know with full details As i could not found name-> > define in excel 2007. > Please assist me . > > Regards, > Abdul > > > > On May 25, 8:18 am, ddadmin2009 wrote: > > Hi, There is a simple solution without creation of a UDF for this. This > is > > old traditional way of doing in excel. Check the article below.. > http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas... > > Hope this helps. > > > > > > > > On Fri, May 22, 2009 at 5:20 PM, Aindril De wrote: > > > Dear Abdul, > > > > > Create the following UDF in a module: > > > > > Function IsFormula(cell_ref As Range) > > > IsFormula = cell_ref.HasFormula > > > End Function > > > > > Now in your conditional formatting, use the formula is option and refer > to > > > this function. and put the formatting you want. > > > > > Only drawback in this is it will consider one cell at a time with this > > > formula. > > > > > Regards, > > > Andy > > > > > On Fri, May 22, 2009 at 9:38 PM, Abdul Hakim >wrote: > > > > >> Dear All, > > > > >> I want to check the cell value via conditional formatting that whether > > >> the value is manual entered or formula. > > > > >> can any body assist me to solving this problem. > > > > >> Regards, > > >> Abdul Hakim... > > > > --http://funwithexcel.blogspot.com/ > > > > -- http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
Hi All I am quite confused for excel 2007. please let us know with full details As i could not found name-> define in excel 2007. Please assist me . Regards, Abdul On May 25, 8:18 am, ddadmin2009 wrote: > Hi, There is a simple solution without creation of a UDF for this. This is > old traditional way of doing in excel. Check the article > below..http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas... > Hope this helps. > > > > On Fri, May 22, 2009 at 5:20 PM, Aindril De wrote: > > Dear Abdul, > > > Create the following UDF in a module: > > > Function IsFormula(cell_ref As Range) > > IsFormula = cell_ref.HasFormula > > End Function > > > Now in your conditional formatting, use the formula is option and refer to > > this function. and put the formatting you want. > > > Only drawback in this is it will consider one cell at a time with this > > formula. > > > Regards, > > Andy > > > On Fri, May 22, 2009 at 9:38 PM, Abdul Hakim > > wrote: > > >> Dear All, > > >> I want to check the cell value via conditional formatting that whether > >> the value is manual entered or formula. > > >> can any body assist me to solving this problem. > > >> Regards, > >> Abdul Hakim... > > --http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
Hi, There is a simple solution without creation of a UDF for this. This is old traditional way of doing in excel. Check the article below.. http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html Hope this helps. On Fri, May 22, 2009 at 5:20 PM, Aindril De wrote: > Dear Abdul, > > Create the following UDF in a module: > > Function IsFormula(cell_ref As Range) > IsFormula = cell_ref.HasFormula > End Function > > Now in your conditional formatting, use the formula is option and refer to > this function. and put the formatting you want. > > Only drawback in this is it will consider one cell at a time with this > formula. > > > Regards, > Andy > > On Fri, May 22, 2009 at 9:38 PM, Abdul Hakim wrote: > >> >> Dear All, >> >> I want to check the cell value via conditional formatting that whether >> the value is manual entered or formula. >> >> can any body assist me to solving this problem. >> >> Regards, >> Abdul Hakim... >> >> >> > > > > -- http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
Andy, Firstly thanks for putting this reply up. This is indeed the best option I know of and I have also been using just the exact way to find out which of the cells in my workbook contain formulas. I do not think it is a drawback that it considers only 1 cell at a time, it is the way the spreadsheets work - each cell has its own formatting definition. Abdul - You can use this UDF and refer it through conditional formatting. You can either apply this UDF to whatever range you want in your spreadsheet. Mohit Khurana, CFA - Excel Matic http://ExcelMatic.blogspot.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Error Checking option.
Dear Abdul, Create the following UDF in a module: Function IsFormula(cell_ref As Range) IsFormula = cell_ref.HasFormula End Function Now in your conditional formatting, use the formula is option and refer to this function. and put the formatting you want. Only drawback in this is it will consider one cell at a time with this formula. Regards, Andy On Fri, May 22, 2009 at 9:38 PM, Abdul Hakim wrote: > > Dear All, > > I want to check the cell value via conditional formatting that whether > the value is manual entered or formula. > > can any body assist me to solving this problem. > > Regards, > Abdul Hakim... > > > > --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---