Download Files:
people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT575-578.xls
See how to count records that match 3 criteria and add conditional formatting to a database with three columns. Also see how to find errors in formulas.
- Excel Magic Trick 575: Conditional Formatting & Counting with 3 Criteria & Find Formula Mistakes ( Download)
- Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria ( Download)
- Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trick ( Download)
- Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function ( Download)
- Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format ( Download)
- Excel Magic Trick 560: Conditional Formatting Select OK, Column Numbers Get Font White ( Download)
- Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting ( Download)
- Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula ( Download)
- Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format) ( Download)
- Excel Magic Trick 491: Count Matches in Individual Cells ( Download)
- Excel Magic Trick 578: Formula To Grade Student Answer Where More Than One Possibility Exists ( Download)
- Excel Magic Trick 582: Excel Errors 9 Types - What They Mean - How To Fix Them ( Download)
- Excel Magic Trick 544: Conditional Formatting Row With Multiple Criteria In Other Columns ( Download)
- Excel Magic Trick 579: MOD function and Date Math Each Successive Date Is Repeated Twice ( Download)
- YTLE#80: Conditional Format MATCH & INSUMBER functions ( Download)
