Based on column A
TRUE/FALSE values column B will display "True" or "False", formula
=IF(A1;"True";"False"). Formula is copied (by dragging) to multiple rows below.
How do I change the formula in all rows in B to
=IF(A1;"Sooo true";"False") without dragging or selecting the column B? I would like to click cell B1, change the text in formula and propagate that change to all cells in column B that copied the formula, so that in all cells that previously was
"True" now would be
Lets assume that cell B5 has value entered by hand
="INACTIVE CELL" that is meant to stay unchanged (dragging would overwrite that cell's value back to formula).