Celebrate Freedom and save 20% OFF on CAclubindia Pro Subscription! Use code: FREEDOM20

How to find cell's containing formula?

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)

21 November 2008

Can anybody tell me which function is to be used to highlight cell's containing formula or vice versa ???

Thnx in advance !!

Reply
Follow
Share

8 Replies

NIKHIL (STUDENT) (45 Points)
Replied 21 November 2008

Originally posted by :CA Prakash Somani
"	Can anybody tell me which function is to be used to highlight cell's containing formula or vice versa ??? Thnx in advance !!	"

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

Upgrade to CAclubindia Pro. Subscribe Now!

CA Subin VR (Practicing CA) (450 Points)
Replied 21 November 2008

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

RAKESH (Almost CA) (2199 Points)
Replied 21 November 2008

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

Roy P Joseph (Sr. Accountant) (24 Points)
Replied 21 November 2008

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.

CA Annie (Chartered Accountant ) (747 Points)
Replied 21 November 2008

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

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

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

CA Sunny Sharma (Service) (234 Points)
Replied 23 November 2008

just click F2

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)
Replied 24 November 2008

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.