blarkdirth
04-18-2006, 12:19 PM
Hi
I have a number of sheets with cells that have conditional formatting applied to change the cell colour to either red, amber or green
I want to be able to count the number of reds, ambers and greens within a set range
Regarding conditional formatting, green is always the first condition, amber second and red the third
I have only looked into this briefly but it looks a difficult / complicated one for me
As a sample I am using range P4:P19
Is there a simple solution?
Thanks for any help
Mark
I have a number of sheets with cells that have conditional formatting applied to change the cell colour to either red, amber or green
I want to be able to count the number of reds, ambers and greens within a set range
Regarding conditional formatting, green is always the first condition, amber second and red the third
I have only looked into this briefly but it looks a difficult / complicated one for me
As a sample I am using range P4:P19
Is there a simple solution?
Thanks for any help
Mark