Prev: copy range
Next: Get column of named cell
From: rslc on 3 May 2010 05:23
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

From: ozgrid.com on 3 May 2010 06:17
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" <russ_lc(a)yahoo.co.nz> wrote in message
news:u4qd%23Iq6KHA.2220(a)TK2MSFTNGP04.phx.gbl...
>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

 | 
Pages: 1
Prev: copy range
Next: Get column of named cell