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

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.
--
Gary''s Student - gsnu200752


"stufree" wrote:

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

EditGo toSpecial, check Formulas
This will select all formulas so you can format them as required

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"stufree" wrote in message ...
|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

For a non-vba method see:

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

On Oct 31, 9:32 am, stufree wrote:
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