ExcelBanter - View Single Post - Counting Coloured Cells

Victor Delta[_2_]

In article , says...

Hi V.D.,

Am Sat, 16 Jan 2016 00:13:19 -0000 schrieb Victor Delta:

The range of cells is AX2:AX930 and the relevant conditional formatting
formula in, say, cell AX3 is
=AND(BN3="10",AY3<"N",OR(ISBLANK(AX3),TODAY()AX3 +60)).

if AX3 is blank the value is 0 and TODAY() is always greater than
AX3+60.
Therefore you only need for CF:
=AND(BN2=10,AY2<"N",TODAY()AX2+60)

And to count the yellow cells you can use:
=SUMPRODUCT(((BN2:BN930=10)*(AY2:AY930<"N"))*(TOD AY()AX2:AX930+60))

Regards
Claus B.

Claus

Very many thanks. That works brilliantly.

Victor