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.