If you're using XL 2007 this is possible without customization. If you're
using an earlier version of Excel you can do this with macros. See:
http://www.cpearson.com/excel/colors.htm for more info.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"GCC" wrote:

I was wondering if it was possible to write a formula in excel that says for
example 'add the numbers in all cells that are coloured purple?'