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.
thank you so much for the quick replay. sorry if my request was unclear - what I meant was that when a value in column A reaches a certain level (eg 15) then a fixed (negative) amount (eg -5) is entered in column B one cell down.
It's a sort of cash flow account. whenever a level is reached in A then a fixed withdrawal needs to be entered in B (one cell down, ie the following day)
It's a sort of cash flow account. whenever a level is reached in A then a fixed withdrawal needs to be entered in B (one cell down, ie the following day)
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.