Learn all about conditional formatting in Excel. Use the pre set rules, create your own rules or apply conditional formatting using Formulas. Learn how conditional formatting works with cell references. Video primarily for students taking the Cambridge ICT IGCSE exams but is a great learning resource for everyone.
Link to the video regarding Absolute/Mixed and Relative references as referenced in the tutorial:    • Excel References, Relative, Absolute ...  
0:00 Intro
0:45 Applying conditional formatting using a cell reference
0:56 understanding Absolute references added by Excel when a cell is used as a reference
7:46 Applying some of the present conditional formatting rules
based on values
based on text
11:55 Creating our own conditional formatting rules
Based on cell values
13:12 Based on cells that contain
14:44 Top/ Bottom ranked values
15:23 Above or below average
16:04 Based on Duplicate or unique values
17:00 Using formulas to apply conditional formatting
Using an extra column to understand how references are used in conditional formatting with formulas
20:18 Applying conditional formatting on cells not being used in a formula
23:29 Analysing why we need Mixed or Relative references
27:53 clearing conditional formatting from selected cells or entire spreadsheet
28:24 Formatting a row instead of just a cell
Analysing the formula and references for 2 dimensions
34:52 Summary