PC Review


Reply
Thread Tools Rate Thread

count coloured cells in a range. Specific colour Red, Green, Blue

 
 
sizz1@hotmail.com
Guest
Posts: n/a
 
      16th May 2006
Hi

I have filled in some cells with different colours, using the fill tool
Red
Blue
Green

I need a formula which will calculate each Red cell in a given range?
I need a formula which will calculate each Blue cell in a given range?
I need a formula which will calculate each Green cell in a given range?

Again the range I need will be two different ranges. E.g A1:B5 and
D15

I look forward to your response

 
Reply With Quote
 
 
 
 
Norman Jones
Guest
Posts: n/a
 
      16th May 2006
Hi Sizz,

See reponse in Programming.


---
Regards,
Norman


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count specific colour from cell range with varied colors? =?Utf-8?B?bmljaw==?= Microsoft Excel Worksheet Functions 1 16th Apr 2007 12:27 PM
Getting range of cells with specific text colour, then using in a COUNTIF formulae CheekyFlash Microsoft Excel Programming 3 11th Oct 2006 05:01 PM
Count coloured cells in range Alberto Pinto Microsoft Excel Worksheet Functions 2 20th Jul 2006 07:33 PM
Count coloured cells in a range sizz1@hotmail.com Microsoft Excel Worksheet Functions 3 20th Jul 2006 01:48 PM
How can I count cells of a specific colour (pattern)? =?Utf-8?B?Tmlja0BEdXJoYW0=?= Microsoft Excel Worksheet Functions 1 29th Nov 2005 10:18 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:12 AM.