Count Conditonal Formatted Cells created by Formula

[sealeas]

Can someone help please. I have an output from Access Crosstab which I apply conditional formatting too, this then shows changes by conditional formatting in RED. If I use some of the VBA code avaialble I can get them to work if the conditional formatting has been set as cell based, but not when it is formula based. The formula in the cell applied by conditional formatting is as follows: =AND($A7=$A6,VALUE(R$3)>VALUE($E7)+1,VALUE(R$3)<VALUE($E7)+10,R7<>R6).

because the number of cells being used is quite large 300000 cells I cannot replicate the formula to the side as it takes forever to calculate. Can anyone help?

 

[sealeas]

Sorry everyone I have sorted it, I found some code in VBA which has done the trick

Many Thanks