Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting fields on criteria in other fields | Excel Worksheet Functions | |||
Counting Coloured Row | Excel Worksheet Functions | |||
Counting Coloured Text | Excel Discussion (Misc queries) | |||
Counting coloured cells | Excel Discussion (Misc queries) | |||
counting coloured cells | Excel Worksheet Functions |