how do I change cell colour to show function used
 

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

how do I change cell colour to show function used
 

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

how do I change cell colour to show function used
 

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

how do I change cell colour to show function used
 

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