Excel Forum

Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function

Add Conditional Formatting to entire row when 3 criteria are met including contains text criteria using the SEARCH function. Also see the AND function and Mixed Cell References. See the SUMPRODUCT Double Negative Problem.

Got a Question? Ask it Here in the Forum.