Count the number of yellow cells within a range

**singerbatfink** · 01-25-2012, 05:30 AM

Hi,

I have a range of cells that have conditional formats to change their colour.

I want to count the number of yellow cells within the range. Can anyone help?

(It's the bright yellow from the colour pallet).

Thanks

**Kyle123** · 01-25-2012, 05:59 AM

Please Login or Register  to view this content.

Called with

PHP Code:


=CountYellow(A1:B20)

**Kyle123** · 01-25-2012, 06:03 AM

Actually, that's not going to work for conditional formatting, I'll post back

EDIT: Can't you use a formula based on the condition to count the number of times it has/hasn't been met? That would be much faster than trying to work with colours