Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditionally formatted list
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditionally formatted list
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum referencing Conditionally Formatted Cells | Excel Worksheet Functions | |||
Conditionally formatted ranges | Excel Programming | |||
Conditionally Formatted Cells | Excel Discussion (Misc queries) | |||
Can you add the number of conditionally formatted cells?? | Excel Worksheet Functions | |||
Selecting cells that have been conditionally formatted | Excel Discussion (Misc queries) |