A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Counting cells with conditional formatting



 
 
Thread Tools Display Modes
  #1  
Old June 2nd, 2010, 02:54 PM posted to microsoft.public.excel.worksheet.functions
AOdoc
external usenet poster
 
Posts: 1
Default Counting cells with conditional formatting

I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria
for the color I'm looking for? Or, is there another formula? Many thanks to
whomever can answer this one!
  #2  
Old June 2nd, 2010, 03:24 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Counting cells with conditional formatting

Easiest to Count on the Condition that turned the cells a certain fill
color.

In 2003 you must use VBA code to count colors.

For those colored by CF it involves extra code.

See Chip Pearson's site for code and instructions.

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


Gord Dibben MS Excel MVP

On Wed, 2 Jun 2010 06:54:01 -0700, AOdoc
wrote:

I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria
for the color I'm looking for? Or, is there another formula? Many thanks to
whomever can answer this one!


  #3  
Old June 2nd, 2010, 03:27 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
 
Posts: 451
Default Counting cells with conditional formatting

Use the formula that the Conditional format is based on to calculate your
count. There is no built-in way of counting color within XL, and even using
VB, counting conditional formats is tricky.

--
Best Regards,

Luke M
"AOdoc" wrote in message
...
I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the
criteria
for the color I'm looking for? Or, is there another formula? Many thanks
to
whomever can answer this one!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:48 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.