I've worked out how to format a row based on one cell in the row but when I
try to copy that formula to my entire column every row's color is conditional
to the value of the first cell, not to the cell for each respective row.

(Same question as SlyGuy2183, but I could not see where he had received a
satsifactory answer. My question is the same).

I have no absolute references, i.e., no "$"s in my formula). Formula is
"cell value (in N3) =K2, color it blue". When I extend that conditional
formula to cell N3, it still refers to cell K2 instead of to cell K3.

'Suggestions?

DOUG