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