I have columns AA through AK that are conditionally formatted to either a red
fill or a green fill.
How can I enter countifs in a column to tell me how many Green fills there
are in a given row.

So if for a particular row only column AA has a green and AD has a green, it
will tell me "2"

Your answer is he
http://www.cpearson.com/excel/CFColors.htm


This is good too:
http://www.cpearson.com/excel/colors.aspx

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Doug" wrote:

I have columns AA through AK that are conditionally formatted to either a red
fill or a green fill.
How can I enter countifs in a column to tell me how many Green fills there
are in a given row.

So if for a particular row only column AA has a green and AD has a green, it
will tell me "2"

Do I place the Function GetStrippedValue in the sheet view code? I have
placed it in the view code and entered =CountOfCF($AA3:$AK3,2) to show number
of green filled and it shows #name.

I noticed that Pearson says:
NOTE: ActiveCondition may result in an inaccurate result if the following
are true:

* You are calling ActiveCondtion from a worksheet cell, AND
* The cell passed to ActiveCondtion uses a "Formula Is" rather than
"Cell Value Is" condition, AND
* The formula used in the condition formula contains relative addresses

The formula I am using is "above average" for columns AA Through AK.

Is this why it is not working?
--



"ryguy7272" wrote:

Your answer is he
http://www.cpearson.com/excel/CFColors.htm


This is good too:
http://www.cpearson.com/excel/colors.aspx

HTH,
Ryan---


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Doug" wrote:

I have columns AA through AK that are conditionally formatted to either a red
fill or a green fill.
How can I enter countifs in a column to tell me how many Green fills there
are in a given row.

So if for a particular row only column AA has a green and AD has a green, it
will tell me "2"

You need to copy more than one function from Chip's site.

Getstrippedvalue

Activecondition

Countofcf

Place these in a general module in your workbook.

All of this may be unnecessary.

Can't you just count by condition rather than color?

In Z1 enter =AVERAGE(AA3:AK3)

Then in another =COUNTIF($AA3:$AK3"Z1")


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 10:15:01 -0800, Doug
wrote:

Do I place the Function GetStrippedValue in the sheet view code? I have
placed it in the view code and entered =CountOfCF($AA3:$AK3,2) to show number
of green filled and it shows #name.

I noticed that Pearson says:
NOTE: ActiveCondition may result in an inaccurate result if the following
are true:

* You are calling ActiveCondtion from a worksheet cell, AND
* The cell passed to ActiveCondtion uses a "Formula Is" rather than
"Cell Value Is" condition, AND
* The formula used in the condition formula contains relative addresses

The formula I am using is "above average" for columns AA Through AK.

Is this why it is not working?

After putting the three functions into a module, when I reset the value in
the column it says "Ambiguous name detected: CountOfCF"


--
Thank you!


"Gord Dibben" wrote:

You need to copy more than one function from Chip's site.

Getstrippedvalue

Activecondition

Countofcf

Place these in a general module in your workbook.

All of this may be unnecessary.

Can't you just count by condition rather than color?

In Z1 enter =AVERAGE(AA3:AK3)

Then in another =COUNTIF($AA3:$AK3"Z1")


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 10:15:01 -0800, Doug
wrote:

Do I place the Function GetStrippedValue in the sheet view code? I have
placed it in the view code and entered =CountOfCF($AA3:$AK3,2) to show number
of green filled and it shows #name.

I noticed that Pearson says:
NOTE: ActiveCondition may result in an inaccurate result if the following
are true:

* You are calling ActiveCondtion from a worksheet cell, AND
* The cell passed to ActiveCondtion uses a "Formula Is" rather than
"Cell Value Is" condition, AND
* The formula used in the condition formula contains relative addresses

The formula I am using is "above average" for columns AA Through AK.

Is this why it is not working?

.

So you have decided to go with the color functions rather than the Z1
=AVERAGE(range_to_average)?

The error message "ambiguous name" would indicate you have duplicate
CountOfCF functions or you have named a module CountOfCF.

Do you now have the three functions in a general module?

Did you delete the functions you had placed in in the sheet module?


Gord

On Fri, 11 Dec 2009 19:23:01 -0800, Doug
wrote:

After putting the three functions into a module, when I reset the value in
the column it says "Ambiguous name detected: CountOfCF"