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