View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?