Challenge 2: Recording a Macro That Acts on Whatever Row Is Selected — Solution Walkthrough

Required setting: Developer > Use Relative References, turned ON
before clicking Record Macro.

Explanation:

With Use Relative References ON, the macro records its actions
relative to wherever the selection happens to be at the moment
recording starts, rather than hard-coding the exact row you recorded
on. Selecting row 1 while recording (with the toggle on) produces a
macro that, when later run, bolds and colours whichever row is
CURRENTLY selected — row 1, row 15, row 200, whatever the user has
selected right before running it.

What would go wrong recording with the default (absolute) setting instead:

Without turning the toggle on, the recorder captures the ABSOLUTE
address of whatever row you selected while recording — e.g. literally
"Rows(1:1)" if you recorded on row 1. Running that macro later, even
with a completely different row selected first, would ignore the
current selection entirely and always jump back to bold and colour
row 1 specifically — exactly the "always returns to the exact
recorded cells" behaviour this chapter describes as the recorder's
default. For a report where the actual header row varies each time,
an absolute-reference macro would silently format the wrong row every
time it's run on a report shaped differently than the one it was
originally recorded against.

Notes:
- This is the same underlying relative-vs-absolute distinction from
  Excel Fundamentals Chapter 3, just applied to recorded ACTIONS
  instead of cell references inside a formula — the "does this move
  with context, or stay fixed" question is identical in both cases.