try this on cip's site
http://www.cpearson.com/excel/CFColors.htm

--


Gary


wrote in message
oups.com...
Hi, is there a way for me to get the sum of cells that are green based
on the conditional format I set for that column?