Count Conditional Formatting?

[tinfanide]

Please see the file.
Thought of DSUM or SUBTOTAL but seemed not good for that purpose (stated in the file).


Thank you for any help.

Count_ConditionalFormatting.xlsx

[macropod]

You need to use a formula that invokes the same rules as your conditional formatting. For example:
=((B$7/2<B2)*(B$7/2<C2))<>0

[tinfanide]

Originally Posted by macropod

You need to use a formula that invokes the same rules as your conditional formatting. For example:
=((B$7/2<B2)*(B$7/2<C2))<>0

Yes, I got it from your example. Thank you very much!