See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DKY" <[email protected]> wrote in message
news:[email protected]...
>
> I have a spreadsheet in which there is a calendar. On this calendar are
> cells for the days. In these cells for the days we use colors for
> Vacation (Purple), Holiday (Pink), Unpaid Absences(Green) and Late
> days(Yellow). At the top of the page I want a cell that tells me the
> number of Purples are in a range (B10:X66) and how many pinks, greens
> and yellows there are. Is there a way to use the 'Count' to count
> colors in a range?
>
>
> --
> DKY
> ------------------------------------------------------------------------
> DKY's Profile:
http://www.excelforum.com/member.php...o&userid=14515
> View this thread: http://www.excelforum.com/showthread...hreadid=499846
>