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