Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Counting coloured cells?

I'd like to know how we can count coloured cells?

i.e

If cells A1 C1 E1 F1 and G1 are coloured, Id like to know how I can see the
total coloured cells in H1?

I suppose its a little bit more complicated than it looks. Any help would
be appreciated. Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Counting coloured cells?

See your other post. No need to ask again.
--
David Biddulph

"Atomic" wrote in message
...
I'd like to know how we can count coloured cells?

i.e

If cells A1 C1 E1 F1 and G1 are coloured, I'd like to know how I can see
the
total coloured cells in H1?

I suppose it's a little bit more complicated than it looks. Any help would
be appreciated. Thank you.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default Counting coloured cells?

see your other post, 2 posts up from this one.

"Atomic" wrote:

I'd like to know how we can count coloured cells?

i.e

If cells A1 C1 E1 F1 and G1 are coloured, Id like to know how I can see the
total coloured cells in H1?

I suppose its a little bit more complicated than it looks. Any help would
be appreciated. Thank you.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting coloured cells SNC-DW Excel Worksheet Functions 3 October 13th 09 11:52 AM
Counting coloured cells SNC-DW Excel Worksheet Functions 0 October 12th 09 12:35 PM
Counting coloured cells SNC-DW Excel Worksheet Functions 0 October 12th 09 12:35 PM
Counting coloured cells amvena Excel Discussion (Misc queries) 2 August 19th 05 02:40 PM
counting coloured cells Tony Excel Worksheet Functions 3 April 7th 05 10:17 AM


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

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

About Us

"It's about Microsoft Excel"