If it is not conditional formatting colour, see
http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"teresa" wrote in message
...
Hi,

Trying to create a function which adds all cells in Column Y which are
formatted
in 'traffic green' color

Thks