Re: countif based on fill color

From: "Peo Sjoblom" <terre08@xxxxxxxx>
Date: Thu, 12 Jan 2006 18:22:13 -0800

Not possible with built in functions unless you can use the criteria which made you colour them in the first place, otherwise you will need code, either a macro or a UDF

http://www.cpearson.com/excel/colors.htm

--
Regards,

Peo Sjoblom

Portland, Oregon

"edmcf@mot" <edmcf@mot@discussions.microsoft.com> wrote in message news:0638FF84-EB6F-4474-9CAE-6F4BEC1746F9@xxxxxxxxxxxxxxxx

Can anyone tell me how to do a countif based on cell fill color? I want to count all cells I've filled in red.

Prev by Date: Re: Fv & Emi!
Next by Date: Re: How to return a single value for a range of numbers
Previous by thread: Re: conditional date formula
Next by thread: Re: How to return a single value for a range of numbers
Index(es):
- Date
- Thread

Relevant Pages

Re: RDU light rail program likely dead
... > Yes, there are several criteria, depending on what type of money is ... If federal money is involved, ... > will never get built, but will garner votes, as John pointed out. ... priority - because the cost associated with them would rise .. ...
(misc.transport.road)
Re: Query using database criterion
... The idea is when a user enters blank under any numeric field critreial, he should be presented ALL the records; sureprisingly this works only for text data. ... you said you find the way to count blank cells and also find solution by using two rows for formulas and including them Qry_Criterion range. ... But I am using multiple field criteria to filter the data based on user input under many field headings. ... Some of the field creitera require the formulas to prefixed and/or suffixed wild cards the user input. ...
(microsoft.public.excel)
Re: Inputting criteria into a macro/vb code
... "Dave Peterson" wrote: ... I didn't know the name of the sheet that held the info (or what cells), ... criteria and operator for each of the 3 autofilters will change or be empty, ... Sub TEST() ...
(microsoft.public.excel.misc)
Re: Inputting criteria into a macro/vb code
... If .FilterMode Then ... "Dave Peterson" wrote: ... I didn't know the name of the sheet that held the info (or what cells), ... criteria and operator for each of the 3 autofilters will change or be empty, ...
(microsoft.public.excel.misc)
Re: Inputting criteria into a macro/vb code
... The only operator that I saw that was necessary was in the first filter. ... criteria and operator for each of the 3 autofilters will change or be empty, ... and an operator in cells a1 and a2. ... Sub TEST() ...
(microsoft.public.excel.misc)