counting coloured fields
 

Hi,

I need to keep a tally on how many fields are green in a given row. Is this
possbile? If so how?

counting coloured fields
 

Can you create a formula based on the logic of *why* the "fields" are green?

For example, they're green because they're less than 100 or they're green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row. Is
this
possbile? If so how?

counting coloured fields
 

No, the column doesn't go green until I tell it. It is for a register, and
once I have verified that the number (column) is associated with a person,
then I select entire column, and change it green. That tells me at a glance
what numbers I have verified, and what ones I haven't.

"T. Valko" wrote:

Can you create a formula based on the logic of *why* the "fields" are green?

For example, they're green because they're less than 100 or they're green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row. Is
this
possbile? If so how?

counting coloured fields
 

You'll need a VBA procedure. See this:

http://www.cpearson.com/Excel/colors.aspx


--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
No, the column doesn't go green until I tell it. It is for a register,
and
once I have verified that the number (column) is associated with a person,
then I select entire column, and change it green. That tells me at a
glance
what numbers I have verified, and what ones I haven't.

"T. Valko" wrote:

Can you create a formula based on the logic of *why* the "fields" are
green?

For example, they're green because they're less than 100 or they're green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row. Is
this
possbile? If so how?

counting coloured fields
 

How do I use VBA? I have gone to that website and it is what I want to do,
but I have no clue where to start.

"T. Valko" wrote:

You'll need a VBA procedure. See this:

http://www.cpearson.com/Excel/colors.aspx


--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
No, the column doesn't go green until I tell it. It is for a register,
and
once I have verified that the number (column) is associated with a person,
then I select entire column, and change it green. That tells me at a
glance
what numbers I have verified, and what ones I haven't.

"T. Valko" wrote:

Can you create a formula based on the logic of *why* the "fields" are
green?

For example, they're green because they're less than 100 or they're green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row. Is
this
possbile? If so how?

counting coloured fields
 

Here is another. See http://www.xldynamic.com/source/xld.ColourCounter.html
for a working solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Redsphynx" wrote in message
...
How do I use VBA? I have gone to that website and it is what I want to do,
but I have no clue where to start.

"T. Valko" wrote:

You'll need a VBA procedure. See this:

http://www.cpearson.com/Excel/colors.aspx


--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
No, the column doesn't go green until I tell it. It is for a register,
and
once I have verified that the number (column) is associated with a
person,
then I select entire column, and change it green. That tells me at a
glance
what numbers I have verified, and what ones I haven't.

"T. Valko" wrote:

Can you create a formula based on the logic of *why* the "fields" are
green?

For example, they're green because they're less than 100 or they're
green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row.
Is
this
possbile? If so how?

counting coloured fields
 

"Redsphynx" wrote:
How do I use VBA? I have gone to that website and it is what I want to do,
but I have no clue where to start.

For starters, take away this wonderful sample from my archives:
http://savefile.com/files/377039
CountCellsByFillColor_Using_BobPhillips_ColorIndex _UDF.xls
(Full details inside, nicely packaged:
how to install Bob's udf, how to use it in excel, etc ..)

The link given above still works, just tested the download here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---