Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria

4,909 views · Published 15 March 2011 · 5:48 · Indexed 14 November 2026

Channel: excelisfun · 2011 · Science & Technology

Watch on YouTube

Download Excel Start File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT761-770.xlsx

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how ad add numbers and conditionally format the rows in a data set with NOT criteria. See the functions SUM, SUMPRODUCT, ISNA and MATCH functions. Logical Formulas.
Conditional Format Rows, Conditionally Formatting Rows, Conditionally Format Rows, Conditionally Format Row, Conditionally Formatting Rows, Highlight Rows

More from this channel

• 3:51 YouTubersLoveExcel#19: Steady Growth Cash Flow Formula

  excelisfun

  3,560 views · 23 May 2008

• 3:44 YouTubersLoveExcel#26: Text To Column Trouble

  excelisfun

  3,596 views · 30 May 2008

• 3:41 YouTubersLoveExcel#26.2: Formulas do not like TEXT Time

  excelisfun

  2,016 views · 6 June 2008

• 3:30 YouTubersLoveExcel#34: Hide Columns Copy Problem

  excelisfun

  3,877 views · 11 June 2008

• 9:27 YouTubersLoveExcel#31: Dates, Cash Flow & Logic

  excelisfun

  4,909 views · 11 June 2008

• 1:57 YouTubersLoveExcel#36: VLOOKUP increase based on Rating

  excelisfun

  3,053 views · 16 June 2008

• 7:38 YouTubersLoveExcel#52: VLOOKUP & Workbook References

  excelisfun

  3,914 views · 7 July 2008

• 1:39 YTLE#60: Hide Columns by Grouping

  excelisfun

  4,807 views · 18 July 2008