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