How Can I Read Formatting Data (ie Background Colour)
 

I'm using conditional formatting to rank various numeric data into Green,
Amber, Red cells (ie Good, Average, Bad). I want to then count the number
of "Green" cells. Ican't find a way to do this directly.

PS I'm aware I could replicate the conditional format tests into another are
of the spreadsheet and apply values using @if etc, but was trying to avoid
this if possible.

Thanks
iMartyn

How Can I Read Formatting Data (ie Background Colour)
 

iMartyn

See Chip Pearson's site for this.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 12:51:20 -0800, "iMartyn"
wrote:

I'm using conditional formatting to rank various numeric data into Green,
Amber, Red cells (ie Good, Average, Bad). I want to then count the number
of "Green" cells. Ican't find a way to do this directly.

PS I'm aware I could replicate the conditional format tests into another are
of the spreadsheet and apply values using @if etc, but was trying to avoid
this if possible.

Thanks
iMartyn

How Can I Read Formatting Data (ie Background Colour)
 

Got this working now. Thanksvery much for your (A-Level) help.

"Gord Dibben" wrote:

iMartyn

See Chip Pearson's site for this.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben Excel MVP

On Thu, 8 Dec 2005 12:51:20 -0800, "iMartyn"
wrote:

I'm using conditional formatting to rank various numeric data into Green,
Amber, Red cells (ie Good, Average, Bad). I want to then count the number
of "Green" cells. Ican't find a way to do this directly.

PS I'm aware I could replicate the conditional format tests into another are
of the spreadsheet and apply values using @if etc, but was trying to avoid
this if possible.

Thanks
iMartyn