how do I change cell colour to show function used

[Guest]

I have a spreadsheet with functions created to be applied against figures in
appropriate cells. I would like the cells where the functions are used to
colour code to indicate which function was applied

 

[Guest]

If you want to color all cells having formulas, then:

Edit > Goto... > Special... > Formulas

this selects the cells. Then:
Format > Cells... > Patterns > and pick the color

If you want to color code specific functions, like =SUM(), you will need VBA.

 

[Niek Otten]

Edit>Go to>Special, check Formulas
This will select all formulas so you can format them as required

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet with functions created to be applied against figures in
| appropriate cells. I would like the cells where the functions are used to
| colour code to indicate which function was applied

 

[Lori]

For a non-vba method see:

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