locate and highlight formulae

[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

 

[Juan Sanchez]

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

 

[DDM]

Fleming, to locate all the formulas in a worksheet, press Ctrl+A. Then Edit

Go To > Special > Formulas > OK.

That selects them. To highlight them, you can click the Fill Color button on
the Formatting toolbar.

 

[Michael]

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

 

[Fleming]

thanks - justs what I needed :

 

[Stuckfly]

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.