Groups > microsoft.public.excel.programming > #109205

ColorIndex count function

Newsgroups	microsoft.public.excel.programming
Date	2016-08-24 01:06 -0700
Message-ID	<2dfa0dfc-710e-4cc7-922c-86b5efffbf00@googlegroups.com> (permalink)
Subject	ColorIndex count function
From	"L. Howard" <lhkittle@comcast.net>

Show all headers | View raw

I thought I could alter any number of function examples that count the cells in a range for either the Font color or the Cell.Interior.ColorIndex or both.

I want to count ANY ColorIndex in a range like C4:C14.  Where the call for the function would be something like =ColorCnt(C4:C14). 

So any cell in that range with any of the 56 color index numbers colors would get counted. 

(A separate function for the font of any color might be useful also)

Thanks,
Howard

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

ColorIndex count function "L. Howard" <lhkittle@comcast.net> - 2016-08-24 01:06 -0700
  Re: ColorIndex count function Claus Busch <claus_busch@t-online.de> - 2016-08-24 10:29 +0200
    Re: ColorIndex count function "L. Howard" <lhkittle@comcast.net> - 2016-08-24 03:21 -0700
      Re: ColorIndex count function Claus Busch <claus_busch@t-online.de> - 2016-08-24 12:30 +0200
        Re: ColorIndex count function "L. Howard" <lhkittle@comcast.net> - 2016-08-24 03:58 -0700

csiph-web