Count Conditional Formatting?

tinfanide · #1 10-13-2013, 08:51 AM

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 · #2 10-13-2013, 05:09 PM

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 · #3 10-18-2013, 06:19 AM

Quote:

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting.	Laurie B.	Excel	6	04-09-2012 05:01 PM
Conditional formatting	zanat0s	Excel	4	01-20-2012 03:30 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM
help with conditional formatting	Snvlsfoal	Excel	3	07-03-2011 11:55 PM