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?