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

Reply via email to