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