Excel Forum



Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria


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.





Got a Question? Ask it Here in the Forum.