Use COUNTIF to obtain the count of green font cells. That is, use the same
condition as in your Conditional Formatting criteria for green font.



--
Regards
Dave Hawley
www.ozgrid.com
"rslc" wrote in message
...
I have a conditionally formatted list of dates in red & green fonts, is it
possible to show the green font cells as a percentage of the whole list?

thanks

rslc