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
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:2
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 l
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 traditi
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:
> De
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 spread
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 consid
