Excel Magic Trick 1400

Conditionally Format Row in Class Enrollment Table with Complex Criteria

DESCRIPTION

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.

WORKBOOKS

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




Be the first to comment

Leave a Reply