Excel Magic Trick 1400

Conditionally Format Row in Class Enrollment Table with Complex Criteria


See how to Conditionally Format the row in an Enrollment Table when the following conditions are met:
1. Enrollment less than or equal to 15, then format row
2. Name Column can NOT contain: ‘Introduction’
3. Department can NOT be: NURS OR MTH
See the functions: AND, SEARCH, MATCH, and ISERROR in a complex Logical Formula.


Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 134 times – 3 MB

Be the first to comment

Leave a Reply