locate and highlight formulae

  • Thread starter Thread starter Fleming
  • Start date Start date
F

Fleming

I want to be able to locate all formulae in a worksheet and highligh
them in order to trace any cells without formuale that should have the
 
One way:

On the EDIT > GOTO > SPECIAL select Formulas then OK

This will select all cells that contain formulas... then
format as wanted...

Another way:

TOOLS > OPTIONS > VIEW > FORMULAS this will display the
formula in the cells instead of the result...

Cheers
Juan
 
Fleming, to locate all the formulas in a worksheet, press Ctrl+A. Then Edit
Go To > Special > Formulas > OK.
Click to expand...
That selects them. To highlight them, you can click the Fill Color button on
the Formatting toolbar.
 
Also,if you want to view them all, you can highlight the
entire sheet and press Ctrl + ` (Tilde), it's the key next
to the number 1.

Regards
Michael
 
I realize this has already been resolved, but for the benefit of those
who may need another solution, such as myself, go here for a method
that applies conditional formatting to cells that contain a formula:

http://www.j-walk.com/ss/excel/usertips/tip045.htm

The advantage is that it's truly automatic.

In my case I have a column of cells that either contain a value input
by one of several users or a formula to derive a value if none is
entered. I need Excel to apply different formatting depending on how
the values are achieved and keep this formatting updated as users
alter the cell contents. This way users viewing a printout will know
at a glance whether the values were entered or computed, without
relying on users to remember to format the cells manually as described
elsewhere in this message thread.
 
Back
Top