Where is it Getting task_start?

[talkinggoat]

This is probably something that's come up before, but I can't quite get google to understand what I am asking.
I am trying to modify/understand one of these pre-made Excel templates with a Gantt chart to overlay formatting onto cells. It's not the actual chart widget.
It has a conditional formatting rule that refers to task_start and task_stop, etc.
There is an entry in the name manager for task_start, task_stop, etc, but the "refers to" changes, depending on which cell is selected, at the time, on the sheet, itself.
On the sheet, itself, task_start does not show up in the name, at the top-left, although it's one of the options, in the drop-down. Where I'd expect task_start to be, it just shows the cell's normal value.

My question is, how does the formula in conditional formatting know what task_start and task_stop are, if its formula doesn't specifically reference a cell and it's not in the cell's name, at the top, left?
The formula is =and(task_end>=i$5, task_start<j$5)

Follow up is, then, how does task_start know to apply to each cell in the column, individually?

 

[StephenCrump]

It sounds like the range names are using relative referencing.

In the layout below, compare the range names:

N , which I defined in the "usual" way as: =Sheet1!$D$1, and

CellAbove, which I defined as =!A1 when the cursor was in cell A2.

	A	B	C	D
1	Hello		N	2
2	Hello
3
4	2		Goodbye
5			Goodbye
6
7			2
Sheet1

Cell Formulas
Range	Formula
A2,C5	A2	=CellAbove
A4,C7	A4	=N

Named Ranges
Name	Refers To	Cells
N	=Sheet1!$D$1	C7, A4