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