![]() |
|
#1
|
|||
|
|||
|
Hi!
Yesterday, someone help me with a formula which is working super. Now I realized that I need to count the cells which I applied a conditional formatting. I know this can only be accomplish with Vba but I don't want to use it. So I was thinking if count if or ifs can help me. The problems is I have tried and is not working. Here is what I want I have this for the conditional formatting to turn the cell red =AND($A5<>"",$G5<0.7) Is it possible to count all the cells in a row A5:A44<>"",G5:G44<.07 that meet the same conditions? Thanks for always helping Liz |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
COUNTIFS returning Value Error
|
ubns | Excel | 1 | 04-16-2015 02:00 PM |
| Need help building COUNTIFS solution | 676nova | Excel | 9 | 02-27-2015 12:50 PM |
| COUNTIFS Help Needed | OTPM | Excel | 2 | 04-09-2014 08:32 AM |
Countifs and Sumproduct
|
Algo | Excel | 6 | 11-13-2012 07:44 AM |
| countifs? | sonyaturpin | Excel | 1 | 05-23-2012 08:29 AM |