how to highligh excel Formulas

K

kamakshi

I want to highlight the values in the worksheet which have
been calculated by using a formula so that I can identify
easily all the values that have been calculcated by using
formulas
 
P

Paul

kamakshi said:
I want to highlight the values in the worksheet which have
been calculated by using a formula so that I can identify
easily all the values that have been calculcated by using
formulas
Click to expand...

Edit > Go To > Special > Formulas
will select all cells containing formulas.
You can then apply a suitable format (for example, coloured background) to
them all together.
Of course, if you subsequently add/remove formulas, you must add/remove such
formatting.
 
Top