View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default count colored cells in excel

Hi

You need to count the cells matching the condition you set in your CF
formula.
Post your CF formula, and perhaps we can help you.

--
Regards
Roger Govier

"Maddog" wrote in message
...
Need a way to count the number of colored cells in a column that are
filled
with a specific color via conditional formatting.

Found a VBA script on the internet for a ColorFunction code that will
count
colored cells if manually filled. Doesn't work for those filled via
conditional formatting.

Any help would be appreciated.

Thanks!