How to find cell's containing formula?

By using the Ctrl+column(the key which is Above tab)

just go to the cell u want to trace the formula; and press F2, you can see the formula.

press F2 or Ctrl+graveaccent the key above the tab button .............

Here is the way to locate the entire cell in a worksheet containing Formula,

• Select Insert, Name, Define.
• In the Define Name dialog box, enter the following in the 'Names in workbook' box                 

                 Formula

• Then enter the following formula in the "Refers to" box

=GET.CELL(48,INDIRECT("rc",FALSE))

Click Add, and then OK. 

• Select all the cells to which you want to apply the conditional formatting.
• Select Format, Conditional Formatting
• In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and then enter this formula in the adjacent box (see the figure below):

=Formula

• Click the Format button and select the type of formatting you want for the cells that contain a formula. (It is better to give a particular colour)
• Click OK . It will work.

U can record a macro to shade all the cells with formulas.

Go to the Formula cell and then click F2 to see the Formula

just click F2

Thnx NIKHIL and thnx to all of u too. F2 function just show the formula but i wants to highlight cells containing formula and thats wht answered by Nikhil and rakesh.

One more thing even after "{CTRL+` (Grave accent)} i am not able to use filter command!!! please help..

Further thnx to Roy P Joseph for giving addition knowleadge.