Forum Discussion
Solved
conditional formatting to reference an adjacent cell
Hi, most grateful if someone could help me with this. I need a conditional formula that would do the following: If A1 > 15 then B2 = -5 is this poss? thanks in advance
Only a formula entered into cell B2 is able to set the value of B2. You could have
= IF(A1>15, -5, other)
but that will prevent you entering any other values into column B. Any other values would have to be generated from the formula.
Only a formula entered into cell B2 is able to set the value of B2. You could have
= IF(A1>15, -5, other)
but that will prevent you entering any other values into column B. Any other values would have to be generated from the formula.
