Thanks a lot. it solve my problm. On May 26, 7:39 am, ddadmin2009 <ddadmin2...@gmail.com> 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 <abdulhakimk...@gmail.com>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 <ddadmin2...@gmail.com> 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 <aind...@gmail.com> 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 <abdulhakimk...@gmail.com > > >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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---