Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 97: Count Conditional Formatting?
use count or countA
Check the conditions to find out if conditional formatting is applied. You can't read it directly from the cell. -- Regards, Tom Ogilvy "simsjr" wrote in message ... Hello, Anyone know how to make Excel 97 count all the cells in a column and count how many have conditional formatting applied? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 97: Count Conditional Formatting?
My interpretation of conditional formatting applied was that the conditions
specified in at least one of the conditional formatting conditions is being meet and some formatting is being applied. Norman's is that the cells have been formatted with conditional formatting. Just for clarification. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... use count or countA Check the conditions to find out if conditional formatting is applied. You can't read it directly from the cell. -- Regards, Tom Ogilvy "simsjr" wrote in message ... Hello, Anyone know how to make Excel 97 count all the cells in a column and count how many have conditional formatting applied? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT IF - Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting based on character count | Excel Worksheet Functions | |||
COUNT CELLS WITH CONDITIONAL FORMATTING | Excel Worksheet Functions | |||
Count and Sum with Conditional Formatting Problem | Excel Worksheet Functions | |||
Count Conditional Formatting | Excel Programming |