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

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" <(E-Mail Removed)> wrote in message
news:u4qd%(E-Mail Removed)...
>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