Just ensure you use an absolute address to keep the input cell address from changing.
Highlight entire rows
To highlight entire rows with conditional formatting when a value meets specific criteria, use a formula with a mixed reference that locks the column. In the example shown, all rows where the owner is "bob" are highlighted with the following formula applied to B5:E12: =$D5="Bob" Note: CF formulas are entered relative to the "active cell" in the selection, B5 in this case.
