I need to count the number of cells that have a specific color formatting.
(example: making a calendar and highlighting vacation days in yellow
background....wanting to total all cells background of color X). possible?

IMO, it would be easier to denote a Vacation with a letter V then do a
simple COUNTIF on the letter V. Otherwise, you need VBA code:

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

--
Biff
Microsoft Excel MVP


"Suz_c_mitchell" wrote in message
...
I need to count the number of cells that have a specific color formatting.
(example: making a calendar and highlighting vacation days in yellow
background....wanting to total all cells background of color X). possible?

Nothing built into excel allows you to do this.

But you could use a user defined function like the ones from Chip Pearson:
http://cpearson.com/excel/colors.aspx


Suz_c_mitchell wrote:

I need to count the number of cells that have a specific color formatting.
(example: making a calendar and highlighting vacation days in yellow
background....wanting to total all cells background of color X). possible?

--

Dave Peterson

I need the calendar dates preserved, so highlighting the days when figuring
out one's schedule is the easiest way for school administrators. We have to
plan and submit our vacations days a year in advance, so I wanted a counter
to track the days as they are picking them. Thanks though :)

"T. Valko" wrote:

IMO, it would be easier to denote a Vacation with a letter V then do a
simple COUNTIF on the letter V. Otherwise, you need VBA code:

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

--
Biff
Microsoft Excel MVP


"Suz_c_mitchell" wrote in message
...
I need to count the number of cells that have a specific color formatting.
(example: making a calendar and highlighting vacation days in yellow
background....wanting to total all cells background of color X). possible?

wow...would have never guessed Excel would miss that one! I see so many uses
to Countif X-color too!! Your link (albeit probably dead-on), is a little
more than a basic function insert for sure--a little daunting indeed :) But
I appreciate the thought...thanks :)

"Dave Peterson" wrote:

Nothing built into excel allows you to do this.

But you could use a user defined function like the ones from Chip Pearson:
http://cpearson.com/excel/colors.aspx


Suz_c_mitchell wrote:

I need to count the number of cells that have a specific color formatting.
(example: making a calendar and highlighting vacation days in yellow
background....wanting to total all cells background of color X). possible?

--

Dave Peterson