ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Counting coloured cells? (https://www.excelbanter.com/excel-worksheet-functions/249810-counting-coloured-cells.html)

Atomic

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.

David Biddulph[_2_]

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.




JLatham

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.



All times are GMT +1. The time now is 05:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com