Data Lookup

[niting]

Hie forum,


Is there a formula or a method wherein, any entry where manual entry is punched, is highlited or picked off. eg if all the cells in a column contains formulaes with very few contianing formulas and adjustements like + some figure.


I did try CTRL+~, but then I had to scroll the whole worksheet which contains some 500 rows of dats.


Thanks

Nitin Gupta

 

[Hui]

Niting

You can use a User Defined Function as below and then Conditional Formatting

Copy the following code to a Code Module in VBA (Alt F11)

[pre]

Function IsFormula(Target As Range)
IsFormula=False
If Target.HasFormula Then IsFormula = True
End Function

[/pre]

Select the all cells you want to investigate

Goto Conditional Formatting

New Rule

Use a Formula

use the formula: =IsFormula(Cell)

Put the cell reference to the upper left cell of the range

Set your format

apply


You can also use it on single cells as a spreadsheet formula

eg: =IsFormula(C1)

and it will return True if C1 has a Formula