No. Using formulas against color is not possible unless you use VBA.
Perhaps Colo's article will help you:
http://puremis.net/excel/code/072.shtml
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"kirkyringo" wrote in message
...
Hi everyone,
I am trying to add the numbers in fields that are highlighted in a
specific
colour. I believe this is done with the IF function, can someone assist
in
showing me how to put the formula together as an example.

Thanks.