Excel - Dynamic Named Ranges and Conditional Formatting

This video explains how to create dynamic named ranges using the Excel function OFFSET.

Named ranges are useful Excel features as they allow you to refer the name in a formula rather than the cell reference. This means that your formulas become easier to read and debug. A dynamic named range allows you to name a range in Excel where the size of the range can change depending on inputs in your spreadsheet.

It also demonstrates how to use conditional formatting to reproduce Excel styles such as Output or Calculation on dynamic ranges.