Forum Discussion
COUNTIFS formula question
I have over 90 lines that I used a COUNTIFS formula, with 3 criteria, to identify specific companies.
Is there a way for me to EASILY find the two companies, out of 90, that meet that criteria?
1 Reply
Hi Matt,
Depends how you would like to identify these companies. You may use Conditional formatting with formula in rule
=($P4<1)*($I4>4)*($L4<2)
apply it to $c4:$c10 and fill matched cell by green.
See attached
